Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Workbook Workbook is offline
external usenet poster
 
Posts: 121
Default VLOOKUP

=VLOOKUP(B7,C4:D33,2,0), how can I modify this so that it works when B7 is on
Sheet 1 but C4:D33 are on Sheet 2?