Hi Biff
now why didn't that work the first 3 times i tried it before posting!!!!
.... thanks, it works now
Cheers
JulieD
"Biff" wrote in message
...
Hi!
Try this:
=VLOOKUP(5,INDIRECT(MID(A1,4,2)),2,0)
Biff
-----Original Message-----
Hi
i have a text string in cell A1 e.g.
ABCXYDEF
the XY bit will change.
What i want to do is lookup a value in a table that has a
range name of XY
e.g. =VLOOKUP(5,mid(A1,4,2),2,0)
but this doesn't seem to work.
how can i do this?
Cheers
JulieD
.
|