Thread: returning multiple cell values from a vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
  
Posts: 411
Default returning multiple cell values from a vlookup
Hi Susan,

try changing the col_index_num and pasting the formula in the next
column and copy down.


In worksheet B, In column b:

=VLOOKUP(SheetA!$A$1,SheetA!$A$1:$F$10,2,FALSE)

Column C put:
=VLOOKUP(SheetA!$A$1,SheetA!$A$1:$F$10,3,FALSE)

Column D put:
=VLOOKUP(SheetA!$A$1,SheetA!$A$1:$F$10,3,FALSE)


etc.

Dan
Reply With QuoteReply With Quote