Hi Dav

Thanks a lot, this cleared it up for me now. It works! Yippeeee!!

Thank you, thank you, thank you!

"Dav" wrote:


Its not clear what you require, if you wish to lookup from 2 places can
the item exist in both arrays? If it can only exist in one array

if(isna(firstloookup),secondlookup,firstlookup)

Assuming that the value must exist in one of the 2 arrays

but you need to provide more information as to what you are trying to
achieve. Are you returning numbers or text?

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=573759