hello
i m using this vlookup formula to look the value..
VLOOKUP(D10,'OL BC'!E:F,2,0)
and
i m using this sumif formula to sum of value...
=SUMIF('OL BC'!E:E,ENTRY!D10,'OL BC'!F:F)

i want to combine them, first lookup the Criteria then sumif the criteria
but i want sum of
'OL BC'!E:F
with criteria D10

thanx