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.

"Sean Timmons" wrote:

yes. Just type your search value in the vlookup, then click the columns you
want in your search on the other workbook.

"Narnimar" wrote:

Do I have any Option in excel to vlookup for an unique Text in another file
and return its address?