VLOOKUP Question

[sfowlow]

Looking to set up a vlookup formula in a financial spreadsheet that pulls the dollar value of cells with the description of "To Be Reimbursed"

Dollar Values are in Column C
Descriptor "To Be Reimbursed" is in Column F

Would like a formula to be placed in I2 that looks up all of the values to be reimbursed and calculates the Total Amount to Be Reimbursed

 

[Aladin Akyurek]

Looking to set up a vlookup formula in a financial spreadsheet that pulls the dollar value of cells with the description of "To Be Reimbursed"

Dollar Values are in Column C
Descriptor "To Be Reimbursed" is in Column F

Would like a formula to be placed in I2 that looks up all of the values to be reimbursed and calculates the Total Amount to Be Reimbursed

Looks like:

=SUMIFS(C:C,F:F,"To Be Reimbursed")

 

[sfowlow]

That works perfectly, Thanks!

 

[Aladin Akyurek]

That works perfectly, Thanks!

You are welcome.