View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Vlookup Across 2 AND down two rows

Use a combination of INDEX( ) and MATCH( ) - match will find the
relative position of 1237 in the first list (to which you can add 2),
then INDEX allows you to go to the same row in a different list.

Hope this helps.