Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup & return multiple unique values | Excel Worksheet Functions | |||
Return text not excel address | Excel Worksheet Functions | |||
USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
VLOOKUP return text not date | Excel Worksheet Functions |