I am not very advanced in excel and trying to use vlookup to sum two cells.
The value I need to search for is in "Q4". The range I need to lookup the value in is (A4:F100) and indexed on column "A". If value is found then I need cell "S4" to display the sum of O4 and that found in column F (corresponding to the line the value was found in).
Thanks for your assistance.
You mean to say that the value in Q4 may be in any cell in the range A4:F100?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
It is in fact at any place in column "A", but once it's found I need to use the value in "F" of the same row it was found in.Originally Posted by Excel Fox
=if(isnumber(match(q4,a4:a100,0)),sumif(a4:a100,q4 ,f4:f100)+o4,"Not Found")
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks