forum.ozgrid.com/index.php?attachment/70563/Sometimes using vlookup to locate a specific piece of data is easy. This time I want to do a 'reverse' search.
As in the test.xlsx, each kid may only select one type of fruit. What I want to do is: input the name of kid in F3 and his/her favourite type of fruit will be shown in G3. What is the formula in G3?
Thanks for your help.
Sorry, When input Peter, should be Banana.