hello
i m using this vlookup formula to look the value..and![]()
VLOOKUP(D10,'OL BC'!E:F,2,0)
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 ofwith criteria D10![]()
'OL BC'!E:F
thanx
Bookmarks