LinkBack URL
About LinkBacks
I want to have C9 populated with a budget type from H1, I1 or J1. How do I create the formula that checks which budget type the value in F9 is?
I am using excel very infrequently.
Screen Shot 2014-05-18 at 12.52.26.jpg
thx, andreas
I want to have C9 populated with a budget type from H1, I1 or J1. How do I create the formula that checks which budget type the value in F9 is?
I am using excel very infrequently.
Screen Shot 2014-05-18 at 12.52.26.jpg
thx, andreas
Hi, see the attached sheet. If you wish to ask further questions, please do so - but please upload a sheet and not a screen shot.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl + Shift + Enter instead of just Enter. i.e. after placing the formula in C9, hold down the Ctrl + Shift and then press Enter.
and then drag down.
Please Login or Register to view this content.
Is this what you want?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Here is another option:Formula:
Please Login or Register to view this content.
Still, I think Glenn's solution is the easiest and best.
Last edited by Jacc; 05-18-2014 at 09:37 AM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Hi Glen – super helpful. Didn't think about restructuring the data and using a vlookup.
However, there seems to be an issue with the names of my budgets. How can I make vlookup look for the exact text values? I mustn't change the texts.
As requested, here's the "amended" excel file:
Last edited by avg_sum; 05-18-2014 at 12:01 PM.
My mistake... Or rather VLOOKUP's mistake. Unless specified otherwise, it'll look for an approximate match. The false statement requires it to find an exact match. The four IMAS variants confused it totally. Two alternatives:
Enter this into C9 & drag down
Formula:Please Login or Register to view this content.
Last edited by Glenn Kennedy; 05-18-2014 at 12:52 PM.
That did it! Perfect, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks