Issue in Vlookup or Index Match Function.

[theLEARNER1991]

Issue in Vlookup or Index Match Function.



I am facing issue in using Vlookup or Index Match Function.

Two system generated excel file are used to extract data which is pasted in a single excel.

First table contains

Column A - ACCOUNT_NO,

Column B - STATUS,

Column C - ACCOUNT_NAME,

Column D - SCHME,

Column E - CLEAR_BAL,

Column F - ADDRESS,

Column G - E_MAIL,

Column H - MOBILE_NO

Second Table contains

Column K - ACCOUNT_NO,

Data to be extracted are

Column Q - ADDRESS

Column R - E_MAIL

Column S - MOBILE_NO

I wish to search account number mention in column K in first table return related values in Column Q, R & S

Formulas which I have used are

=VLOOKUP(K3,$A$2:$H$2210,6,TRUE) it shows error as #NA

&

=INDEX($A$2:H2210,MATCH(K3,$A$2:$A$2210,0),MATCH(Q$2,$A$2:$H$2,0)) it shows error as #NA

I would be eagerly waiting for reply.



Regards,

 

[Peter_SSs]

I would be eagerly waiting for reply.

Two things would probably help with that.

1.
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

2.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.