I"m trying to get a sumif to return a result from a group of text items based on what is selected in another cell. The Pull down for selecting an account code is cell "E10" (Pull down for the Range called "CAM_CODE") and I want cell "g10" to return the corresponding text description found in the range called "Description"
Thanks in advance and sample spreadsheet attached.
Last edited by edbhome; 04-21-2020 at 08:12 AM. Reason: Resolved
What on Earth does this have to do with SUMIF???
I believe a simple lookup formula will do it:
=IFNA(VLOOKUP(E10,$M$9:$N$33,2,0),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
try
=IFERROR(INDEX($N$9:$N$32,MATCH(E10,$M$9:$M$32,0)),"")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I'm not a pro so I thought using sumif might be the way to go. Obviously I was wrong and many thanks for giving me a solution.
Be safe and be well,
Ed
No worries.
The clue is in the name, really: SUMIF will sum a range of numbers if a criterion in that column or in another column is met.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks