Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup and return cell address
I receive a huge spreadsheet from a vender each month. I'm trying to find a
client code in this spreadsheet listed somewhere in column A. After finding the client code, I want the vlookup to return the cell address that the client code is in (Ex. A9). Thanks for the help, Thomas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup and return cell address
vlookup will only return a piece of data that's in the table. Could you use
MATCH instead? If your match looks in a single column, it returns the row# w/in the table where the match was found. So if you use =match(a1,Sheet2!a:a,false), the return value will be the row number. You could turn that into an address: ="A" & match(a1,Sheet2!a:a,false) HTH. --Bruce "Thomas" wrote: I receive a huge spreadsheet from a vender each month. I'm trying to find a client code in this spreadsheet listed somewhere in column A. After finding the client code, I want the vlookup to return the cell address that the client code is in (Ex. A9). Thanks for the help, Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |