Hi all



I'm using vlookup to look for values in one table compared to another table. On my Excel2007 spreadsheet, my table that has all the values I want to search for begins at A32 downwards to A51.

I'm struggling to get the vlookup_value to be recognised as a table and not just a single cell.

Can anyone help me amend the formula so that it searches for all the values in the table and not just the single value in cell A32. Current formula and spreadsheet attached.

=VLOOKUP(A32,A2:B28,2,0)

Thanks in advance

Ben

Attached Files

Vlookup Table worksheet.xlsx (10.8 KB, 8 views)

What exactly do you mean? Retrieve all names with the same code?
If so just use a filter

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks Peco- What I want to see is all matches of entries in my table (lookup_value) compared to whats in the first table_array.

The spreadsheet attached is just a sample the actual spreasheet has about 1000 rows in each.

(I'm not too worried about the name as I can change the output later).

Hope this makes sense - thanks

Ben

I don't really get it. If you filter on the code it will give you all the names?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post