Forum Discussion
EXCEL-VLOOKUP
I have a little problem with formula: VLOOKUP. I write everything ok (I think so) but my formulas aren't fullfild. I want to write that all time when somebody write their year of the birth, they wil...
Vlookup is comparing 2000 (Cell E15) to values in A2:A13 (Zodiac names). It's not finding a match and thus you are not getting the expected results. Unpivot that list and put year in the first column and Zodiac name in the 2nd column then reference that list in your vlookup and change the column returned from 1(year) to 2(Zodiac Name).
There is a way to do it without un-pivoting the data but that is more complicated. Using your screenshot example it would be:
=INDEX($A2:$A13,CONCATENATE(
IFNA(MATCH($E$15,B2:B13,0),""),
IFNA(MATCH($E$15,C2:C13,0),""),
IFNA(MATCH($E$15,D2:D13,0),""),
IFNA(MATCH($E$15,E2:E13,0),""),
IFNA(MATCH($E$15,F2:F13,0),""),
IFNA(MATCH($E$15,G2:G13,0),""),
IFNA(MATCH($E$15,H2:H13,0),""),
IFNA(MATCH($E$15,I2:I13,0),"")))