Page 1 of 1
Look up value same month from the table
Posted: Mon Mar 21, 2022 1:50 pm
by sna
Hi there!
Greeting to everyone here!
My table is A1 to R12
When I input value in col T
Then I want the same value get in col u
TY
Re: Look up value same month from the table
Posted: Mon Mar 21, 2022 2:09 pm
by Xcelvba
You should to transpose the data with 2 column
=VLOOKUP(T2,$A$1:$B$108,2)
Re: Look up value same month from the table
Posted: Mon Mar 21, 2022 6:11 pm
by norkaz
...
U2
=IFERROR(INDEX($A$1:$R$12,AGGREGATE(15,6,ROW($A$1:$A$12)/(T2=$A$1:$R$12),1),AGGREGATE(15,6,COLUMN($A$1:$R$1)/(T2=$A$1:$R$12),1)+1),0)
Norkaz
Re: Look up value same month from the table
Posted: Tue Mar 22, 2022 5:47 pm
by sna
It will not work if I changed to 1/02/2021....
Re: Look up value same month from the table
Posted: Tue Mar 22, 2022 6:10 pm
by norkaz
..
Please provide the Excel attached and the results that you expect.
Norkaz
Re: Look up value same month from the table
Posted: Fri Mar 25, 2022 4:20 am
by sna
TY,now it is Ok after correction of format