vlookup for an unique Text and return its address?

  • Thread starter Thread starter Narnimar
  • Start date Start date
N

Narnimar

Do I have any Option in excel to vlookup for an unique Text in another file
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Unique Items - Please Help...SOS! 0
Can vlookup work using formula values? 5
Vlookup or Other vs Sort? 1
Vlookup multiple changes 3
VLOOKUPS to Count Unique numbers 1
Combining "IF"statement with "Vlookup" 9
Excel IF statement with vlookup 2
VLOOKUP error #NAME 2

Back
Top