Vlookup formula that adds two columns possible?

I have a vlookup formula that finds a value based on text in a column on the same worksheet the formula is in. It retrieves the value from column 2 in a list on another worksheet. Can I modify the formula to add the value it looks up with a value in column 3 on the same sheet (add columns 2 and 3 together)?

The current formula is:

Please Login or Register  to view this content.

In essence can I make it add together 'Rented Equipment'!$A$1:$B$130,2 with 'Rented Equipment'!$A$1:$B$130,3?

Thank you!

Hi Dopey (no offence !!)

Are you able to post an example workbook? I think i may have it for you but want to check that my understandnig of what you need is correct.

Grimace

See if this is what you are looking for:

This will give you the total sum of column B and C whenever the value in Column A is "Rental Equipment" ....

=sumproduct(--('10-50'!$A$1:$A$130="Rented Equipment"),('10-50'!$b$1:$B$130),('10-50'!$c$1:$c$130))

Try this array formula**:

=IF(ISTEXT(C23),SUM(VLOOKUP('10-50'!C23,'Rented Equipment'!$A$1:$C$130,{2,3},0)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.