Index & Match with columns

P

Peter Atherton

Brian
In sheet1 type =Sheet2!B83

Copy the formula accros the columns

Regards
Peter
 
D

Dan E

Good answer, Straight, to the point, not to complicated! I was wondering why he needed a lookup???
 
Top