How do I write this formula:
Logical Test: IF, D2 = "Contract Signed" OR "Contract Out" OR "Offer"
True: Index(Data[Net%],Match(D1,Data[Unit],0)
False: "-" (or just have the cell be blank)
How do I write this formula:
Logical Test: IF, D2 = "Contract Signed" OR "Contract Out" OR "Offer"
True: Index(Data[Net%],Match(D1,Data[Unit],0)
False: "-" (or just have the cell be blank)
Formula:Please Login or Register to view this content.
Last edited by TMS; 09-12-2016 at 05:52 PM. Reason: Add bracket
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
For False = blank:
Formula:Please Login or Register to view this content.
Last edited by TMS; 09-12-2016 at 05:51 PM. Reason: Add bracket
A little bit shorter
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Or:Formula:Please Login or Register to view this content.
hmmm. doesnt seem to be working, any idea why?
there could be an extra space in one or more of your variables? Like "contract signed "
what message if any do you get when using one of their formulas?
test it using a length formula like =len(d2) if contract signed is longer than 15 or contract out is different than 12 or offer is not 5 then using the quotes around those in the formula making them exact will not work, instead you would have to see what is in the cell and adjust the formula appropriately.
Last edited by Sam Capricci; 09-13-2016 at 09:56 AM. Reason: clarity
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Or post a sample workbook so we can see the data in context.
@csnyder10: any plans to follow up on this question?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks