Hi Peo
the table is range that has been named XY (literally in cells A17:H25)
Cheers
JulieD
"Peo Sjoblom" wrote in message
...
Where's the table?
This works
=VLOOKUP(MID(A1,4,2),C1:D14,2,0)
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"JulieD" wrote in 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
|