![]() |
#5
|
|||
|
|||
![]()
See Excel's help to VLOOKUP.
Your table_array is what you have called phones. First column in the table_array must contain the lookup_value, and it doesn't. The lookup_value is contained in the third column of phones. In my file I showed two workarounds. You will see that the formula in column J: =VLOOKUP([@POAddress];'cutomer Contacts list xero 2101'!$C$1:$D$454;2;0) has table_array C1 ![]() Still another possibility is that you move present column C in sheet customer Contacts list to new inserted column A. (By the way, I deleted a lot of columns in the file I uploaded to reduce the file size. Otherwise I wasn't able to upload - bigger than 500 kb). |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using IF and VLOOKUP | CSTEIGER | Excel | 5 | 11-21-2013 01:36 AM |
![]() |
56_kruiser | Excel | 6 | 08-05-2013 11:45 AM |
Question: Will Vlookup work on this problem? | jnix612 | Excel | 1 | 07-27-2013 12:11 AM |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |
![]() |
bunnygum | Excel | 1 | 03-24-2009 05:10 AM |