P Peter Atherton Jul 31, 2003 #1 Brian In sheet1 type =Sheet2!B83 Copy the formula accros the columns Regards Peter
D Dan E Jul 31, 2003 #2 Good answer, Straight, to the point, not to complicated! I was wondering why he needed a lookup???