If Then Statement using multiple criteria
Hello Excel Guru's,
I am trying to fill in the column labeled department and department 2 from a certain criteria. The criteria is on the left and I don't want to use a vlookup, I assume I could use a if than statment. Does anyone know how I can write this formula? I basically want it to say if the *** is the same, the age is the same than use the correlating department and the same for department 2. Thanks for helping.
Sample.xlsx
Well. In E5, enter the formula with Ctrl + Shift + Enter keys together, then fill the formula down and across
=INDEX(J$6:J$13,MATCH($C5&$D5,$H$6:$H$13&$I$6:$I$13,0))
IF Then Help
Hello,
I thought I posted this but it is not showing on my posts so I will try again.
I am trying to get my IF then statement to use multiple criteria. I basically want it to match on *** and Age, once those match I would like it to put in the appropriate department. Please help...
Sample.xlsx
Thank You so much.
If I understood this correctly, paste into E5 and drag across/down:
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
If that doesn't work, maybe this will....
Place in E5 and drag down
Place in F5 and drag downPlease Login or Register to view this content.
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
For 1 more time this is a duplicate thread but as you have replies in both of your threads i'll merge AGAIN these.
This is my last warning.
Read carefully the forum rules and comply with them or else next time you'll be a banned user.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks