vlookup for an unique Text and return its address?
 

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

vlookup for an unique Text and return its address?
 

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?

vlookup for an unique Text and return its address?
 

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?