Have you tried the help index for LOOKUP?

--
Don Guillett
SalesAid Software

"Simon Lloyd"
wrote in message
...

Hi all,

I am having problems devising a formula to do the following in cell A2
sheet1, i want the cell to lookup a match for A1 Sheet1 in a named
range on Sheet2 and return the value of the cell 3 columns away from
that cell.

So if A1 sheet1 contains the word "Test" i want the lookup to look for
"Test" in the named range (lets say "Find"), lets say "Test" is found
in E3 sheet2 then in A2 sheet1 i want the value of E5 sheet2.

The names are variable for the cells in sheet1 and sheet 2.

Hope you can help!

Simon

P.S i have tried =offset, =match, = index etc and having no joy!


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=465684