Hi,
I have a sheet name "sheet2" in which Row No 1 contains the string and Row 2 contains the string value. And In the sheet3 answers are there. Now I have to do:-
EG :- First It find the Gender into the sheet 3 and and if it finds then lookup the value of Row 2 into that column where Gender finds.
I am attaching a file for your reference.
Bookmarks