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
Bookmarks