Using Vlookup_value is a table not an individual cell?

ms2007 · #1 09-20-2016, 06:57 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pick individual excel line from table to merge to WORD	skiwidad	Mail Merge	1	04-14-2016 05:50 PM
Extracting multiple words from one cell into individual rows while copying all other data	randyaserve	Excel Programming	4	10-05-2015 09:52 AM
Move table cell contents from one table to another table or cell in same table	donaldadams1951	Word VBA	4	02-04-2015 03:54 PM
Changing the size of individual cell	_mike1	Word VBA	1	11-25-2014 05:58 PM
Applying individual border sides to images when pasted into a table	Duvdev	Word VBA	1	03-27-2014 03:12 AM