Hi all,

Right, im working between 2 spreadsheets, pulling accross large amounts
of data, so a lookup seems the most obvious way forward.

Problem is that I need to look up multiple values. I need to lookup
the risk value '2' in range xyz and then find the product in that range
with a 'x' rating and return its name. The product name is in col D,
the value in col DA and the rating in col CX

If that doesnt make sence in short I need to lookup the number 'x'
rated product with a risk value of 'x' in the range xyz and return the
products name,

can someone pls help?


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile: http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=388001