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

Is the number 4 only likely to occur once in your detail sheet? If so,
you can use the VLOOKUP( ) function in the summary sheet to look for a
match in the detail sheet and return a corresponding value from the
same row. I'm not sure, though, what your example summary sheet is
meant to represent, or how the letters are related to the detail sheet.
If you can come back with some further details then i will be able to
elaborate on my suggestion.

Pete

Why does 4 return 7, and 5 return 6?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"JR573PUTT" wrote
in message ...

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

I dunno!

Pete

use the formula "countif", set the criteria "4"


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

Bob,

We sell 4 - 7 times during a day, so we want to now how many times we
sale 4 items to one customer, hope that helps.

Also the vlookup would not work because the left column has to be in
numeric ascending order, and this worksheet would not be that way.

So I figured it out on my own using the index match function.


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