Thread: [Solved] Using Vlookup_value is a table not an individual cell?
View Single Post
 
Old 09-20-2016, 06:57 AM
ms2007 ms2007 is offline Windows 10 Office 2007
Novice
  
Join Date: Sep 2016
Posts: 2
ms2007 is on a distinguished road
Default Using Vlookup_value is a table not an individual cell?
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
File Type: xlsx Vlookup Table worksheet.xlsx (10.8 KB, 10 views)
Reply With Quote