G
greasybob
I'm using a common lookup formula like the following:
=index(B1:B5,match(E1,A1:A5,false),1)
Is it possible to write the above formula to reference entries in cell
as cell numbers?
For example: If cell J1 contains the text "B3" , can a function b
written in place of E1 (in the formula) to reference J1 and use B3 (o
whatever cell number in in J1)?
Hope this makes sense.
Thanks
Bobb
=index(B1:B5,match(E1,A1:A5,false),1)
Is it possible to write the above formula to reference entries in cell
as cell numbers?
For example: If cell J1 contains the text "B3" , can a function b
written in place of E1 (in the formula) to reference J1 and use B3 (o
whatever cell number in in J1)?
Hope this makes sense.
Thanks
Bobb