in column A we need a formula to pick the ISD name from b and c column, please help. Attached is the output in column A.
in column A we need a formula to pick the ISD name from b and c column, please help. Attached is the output in column A.
Hello Andy308,
ISD won't be same in col B&C?
Regards,
Thangavel D
Appreciate the help? CLICK *
hi there. try this in A2:
=IFERROR(INDEX(B2:C2,MATCH("*ISD*",B2:C2,0)),"-")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you very much.
welcome to the forum
For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?![]()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks