My formula is in cell M3
In cell B2 I am choosing from a list - Stage 1, Stage 2, Stage 3, Stage 4, Stage 5
In cell K3 I am choosing from a list - Draft, In Process, Complete
I have created a table to work off - it should be attached.
In cell M3 I want to say that depending on what is picked in B2 to look at that table and bring back the desired result.
How do I do this - I have looked at IF + VLOOKUP but I'm not sure it's what I want??
Please & thank you
attach sample excel sheet
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
You'll find all you need at http://www.contextures.com/xlDataVal02.html
Excel File attached now
Tiny3 ,
Update the expected results , if already updated explain the same again
Punnam
Punnam,
So if we select "Stage 3" in cell B2 and "In process" in cell K3 that cell M3 will automatically populate "Behind Target"
Hi,
Check this
Formula:
Please Login or Register to view this content.
Use Ctrl+Shift+Enter after any change in formula , If necessary update the range as per your requirement from D4:D40 to desired one
Punnam
=INDEX(List!$B$3:$D$30,MATCH($B$2&$K3,INDEX(List!$B$3:$B$30&List!$C$3:$C$30,0),0),3)
Try this formula
Works perfect - thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks