VLookup question

[iangessey]

Hi
Appreciate your help in advance.
I need to get my head around VLOOKUP and hopefully its the answer to my issue.

I have a large set of data with a column of unique ID references. - a months amount.
For a reconciliation i have a sample of data, from that same column of unique ID references that i need cross reference against the full list.

I have attached a csreen grab of the query.
Data in Colum A should appear in Column D, but i only want the results that match displayed

Am i on the right path with a VLOOKUP, or is there a more efficient way?Any help gratefully accepted!

 

[rpaulson]

many different way you could use:

i prefer to count function

in cell(B2) put =COUNTIF(D:D,A2)
this will count how many times the value in cell A2 exists in Column D
fill down as needed

the vlookup option would be =VLOOKUP(A2,D:D,1,0)

 

[saboh12617]

Hello,

Yes, you can either use VLOOKUP or INDEX/MATCH. However, be careful on the "exact match" parameter, you have to set it to "exact match" or you will have false matches.

So the formula, to display only the values found, could be (in B1)

=IFERROR(VLOOKUP(A2; $D$2:$D$????; 1; FALSE); "")

Or

=IFERROR(INDEX($D$2:$D$????;MATCH(A2; $D$2:$D$????;0));"")

The values not found will raise an error, therefore we can use IFERROR and "" to mask them.