Lookup and multiple conditions

I am trying to lookup the value in column H, if these 2 conditions are met, colA=colF and colB=colG. The formula I used seems to work for the first cell, but when I paste it down, i keep getting a N/A. Not sure what the problem is because cell C4 should equal 167974. Any help is appreciated!

Hi

In a blank cell, enter the number 1.

Copy that number then highlight the data in column F, edit, pastespecial, multiply. This will convert the numbers to numbers. This can sometimes happen when items are brought in from different sources.

Most of the formulas will then calculate with no errors.

HTH

rylo

That worked!!!

Thank You.