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.
|