Need help with complex Lookup formula....

V

vpr80

ohhhh I think that will do it....ok one more question.....

If for example cell A1 contains the text "B10" and I want the offset t
start at B10 but the formula to contain A1 as the reference....how do
do that
 
Top