Hi all,

I would like to find a value in a named range and return it in a cell
if this criteria exists....sheet1 A2 if named range value = A1 then
return value from 3rd column away from match same row

So if A1 Sheet1 contains "test" and named range (lets say "Find")
Sheet2 contains "test" (lets say in E2) then A2 Sheet1 should show the
value of E4 Sheet2.

Dont know whether that is clear but its been driving me nuts as i have
tried the Match, Index and Offset functions but without
success..........Can you Help?

Simon


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