Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates

[adammostafa1980]

thnaks so much your video is really great

i tried to download your file but i couldn't where can find it please help... :(

[ExcelIsFun]

Search for:

excelisfun

then go to the excelisfun channel. The video that automatically plays shows how to download the workbooks and also many other excelisfun helpful hints.

[perislav1]

I came up with slightly different array formula for "Collumn Value Returned", I find it more convenient:

{=INDEX(C12:E12;;SUM((C13:E16=­B20)*(COLUMN(C13:E16)-2)))}

PS1:Formula has European settings

PS2:I am a big admirer, keep up, good work!

[ExcelIsFun]

That is a clever formula! Thanks for sharing!