Index/Match where data has duplicate values

[ragatha]

I want to find data in a sheet based on two criteria (like a dual vlookup): Dept # and Object code. When I use the Index with match the data coming into the summary sheet is puling in some intances and not others. And it is not always accurate. What is the best way to lookup two criteria on one sheet against a second sheet where there would be duplcates in either criteria. Thank you for any help.

[FDibbins]

index/match works as follows...
=index(range,match row,match column)

in your formula
=INDEX('Prelim Bud'!$U$2:$U$5627,MATCH($D$5,'Prelim Bud'!$C$2:$C$5627,0),MATCH(C6,'Prelim Bud'!$D$2:$D$5627,0))

you are using 2 rows - MATCH($D$5,'Prelim Bud'!$C$2:$C$5627,0)
and MATCH(C6,'Prelim Bud'!$D$2:$D$5627,0))

see the attached. i added a helper column at E and concatenated C&D and then used a simple vlookup in column G to find what you were looking for.

however, i think what you are trying to do is sum all instances of those combinations? if that is the case, then look at the sumifs() i used on sheet2 column H.

let me knoe if this is what you were after?

[ragatha]

HI - thank you very much! I was trying to do the vlookup one - I spent seriously 4 hours messing with it. Thank you so much