I want to use vlookup function to extract phone numbers from one sheet to another. File is attached, I want to copy phone numbers from customer contact list xero to complete data sheet column j2 but it is not working. Please check and point out the error.

Regards

Attached Files

Customers Mail List_Phones.xlsx (497.0 KB, 13 views)

This message has been deleted.

Here you have a couple of ways to go.

Attached Files

Customers Mail List_Phones_2.xlsx (491.2 KB, 13 views)

Dear Sir,

Thank you for help. Actually, it was sample file and I need to complete my large file. I only want to know what was my vlookup error so that i may be able to correct my own file.

Thank You

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 C1454 so that lookup_value is to be found in the leftmost column of table_array, and col_index_num has been changed to 2.

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).

Thank you Sir. My issue has been resolved now. Regards