Do I have any Option in excel to vlookup for an unique Text in another file and return its address?
N Narnimar Jul 1, 2009 #1 Do I have any Option in excel to vlookup for an unique Text in another file and return its address?
S Sean Timmons Jul 1, 2009 #2 yes. Just type your search value in the vlookup, then click the columns you want in your search on the other workbook.
yes. Just type your search value in the vlookup, then click the columns you want in your search on the other workbook.
N Narnimar Jul 2, 2009 #3 Do you mean if "search value" is in a3 in sh1 of book1 then, =VLOOKUP("search value",[Book1]Sheet1!A:A,1,0) will return "a3"? But when I tried, It does not return a3 which I want.
Do you mean if "search value" is in a3 in sh1 of book1 then, =VLOOKUP("search value",[Book1]Sheet1!A:A,1,0) will return "a3"? But when I tried, It does not return a3 which I want.
