Doh!

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"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


.