MATCH or VLOOKUP or ??

[SMAX]

Hello everyone,

Thank you so much for all the feedback. I was able to use Peo'
example with some success, however, it didn't seem to pull all of th
data from the second sheet to the first sheet. Does anyone have an
ideas as to why this might not have worked?

I will try to upload my example.

Thanks again everyone!!

Guy

PS I added a sample file, but had to rename the .xls to .txt. Pleas
rename the file extention to .xls to view as Excel file

+-------------------------------------------------------------------
|Filename: Sumif - Example.txt
|Download: http://www.excelforum.com/attachment.php?postid=2684
+-------------------------------------------------------------------

 

[hgrove]

SMAX wrote...
...

Thank you so much for all the feedback. I was able to use Peo' example with
some success, however, it didn't seem to pull all of the data from th second
sheet to the first sheet. Does anyone have any ideas as to why thi might not
have worked?

...

No one in their right mind opens files sent by strangers. Explain i
PLAIN TEXT what the problem is IN DETAIL. What formula are you using
Copy it as PLAIN TEXT into to body of your response. Is it returning
number that doesn't seem right? If so, is the number too high or to
low? If there's not too much data, copy your data AS PLAIN TEXT int
the body of your response as well