i want to pull some information from a row where two columns meet my
crieria.

If i were doing this where information in just one column matched i
would use a match() to find the data and then an offset to locate the
data i were after.

Im not sure how to do this with two colums

it almost needs to be like this

offset(A$1,match(and(B:B="AM",C:C="Whole"),0),0)


Please can you help?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=552708