So you want to look at column A in sheet Correction Values and find
"BAAA 2.0" and column B in sheet Correction Values and find "TS" and if
both conditions are met then return the value from column C in
Correction Values?
Try,
=SUMPRODUCT((CorrectionValues!A1:A?="BAAA
2.0")*(CorrectionValues!B1:B?="TS")*(CorrectionVal ues C1:C?))
This will sum the values in CorrectionValues!C1:C? so long as the two
conditions are met in columns A & B. If there is only one occurence it
will only return that one value. The size of your search ranges need to
be the same (i.e. A1:A10, B1:B10, C1:C10) You could name each column
range if you prefer using named ranges vs. cell references.
Does that help?
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=538519