View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 57
Default VLookUP with multiple reference columns

Is there a way to do a Vlookup that refers to more than the first column of
the table. If not, does anyone know an easy way to connvert a table
(multiple rows and multiple columns to a table with only two columns and
multiple rows) so that I can use the vlookup funtion?