| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup where table array is in text format
Hello!
I am trying to do a vlookup where the format of the origin cells are "general" and the format of table array is all in text. I am looking up a combination of alpha and numeric characters on the origin. I know I can't look up 2 different formats but want the vlookup formula to acknowledge the difference. I tried the following formula but it does not work: =VLOOKUP(C9,TRIM('[Copy of MP_Book.xls]Merge Purge Results'!$B$9:$T$286),19,FALSE) It returns an error of #N/A. Any suggestions on how to get the table array of text to be matched with the general value? Thanks for your help! -- Jodie Gardner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array table and vlookup | Excel Worksheet Functions | |||
| vlookup - can't pick up table array | Excel Worksheet Functions | |||
| Vlookup -Want to make table of array optional | Excel Discussion (Misc queries) | |||
| i want to do a vlookup but i want the table array to be changing | Excel Worksheet Functions | |||
| VLOOKUP - 3 Table Array | Excel Worksheet Functions | |||
Threaded Mode
