Results 1 to 4 of 4

Vlookup formula that adds two columns possible?

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2012
    Location
    Mesa, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    17

    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:
    =IF(ISTEXT(C23),(VLOOKUP('10-50'!C23,'Rented Equipment'!$A$1:$B$130,2,FALSE)),"")
    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!
    Last edited by Dopey1956; 05-02-2013 at 05:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1