I am trying to reference a detail sheet to a summary sheet:

detail sheet
a b
number occurence
4 7
5 6


summary sheet:

a b c d e
4 6 7 10 1

I want a formula on the summary sheet to look up the occurence of 4,
and return a value of 7 for the number 4.

I was trying some sumif formulas with no successs


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=513424