Hi, am onto the last leg of my worksheet. but i am a little stumped at the moment.
Example cells highlighted pink
If L5,M5,N5 are matching whats in the table AX4 to AZ15 then show the correct specific text in AE5 from the column BA...
Hope that makes sense. I will attach the worksheet "testforlastleg3". Thank you.testforlastleg (3).xlsx
Last edited by cjohnr1388; 04-13-2016 at 09:31 AM.
Enter this array formula into AE5 copied down
=INDEX($BA$4:$BA$15, MATCH(M5&L5&N5, $AX$4:$AX$15&$AY$4:$AY$15&$AZ$4:$AZ$15,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks