I'm looking for a way to extract values out of my data. I've attached an example of what I'm looking for and working with.
In my example if an invoice has a value of Confirmed I want to take the values from column C & D. When it does I want it to show in the format I have in column I.
Thanks for any help
Try this
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
How about this?
=IF(F2="Confirmed","Order-"&TEXT(C2,"m/d/yyyy")&" Invoice-"&D2,"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Put this formula in cell I2:
=IF(F2="Confirmed","Order-"&TEXT(C2,"m/d/yyyy")&" Invoice-"&D2,"")
then copy down as required.
Hope this helps.
Pete
Thanks this works perfectlyOriginally Posted by AlKey
Try this
Formula:Please Login or Register to view this content.
It doesn't check to see if column F contains "Confirmed".
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks