Hi
There a 3 different statused in another table for 1 ticket but I just need show the name and date for status="Approved-CM" only in the master table.
I tried using this formula but it's not working
=IFERROR(INDEX(WOHistoryName,MATCH(1,--(WOHistoryStatus="Approved-CM")*--(WOHistoryID=A3),0)),"")
Attached is the example of the file. Please advise. Thank you.
Can you explain what's not working and give your expected outcomes?
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.
Try
F3=IFERROR(INDEX(WOHistoryName,MATCH(1,INDEX(--(WOHistoryStatus="Approved-CM")*--(WOHistoryID=A3),),0)),"") and drag over and down
Formula:
Please Login or Register to view this content.
After paste the formula press F9 key.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you. The formula is working beautifully.
I know a simple index match but I don't understand why need to add an index within the match. Can anyone please explain.
To avoid array formula (Shift+Ctrl+Enter)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
@Suchetherrah, Shiv is absolutely right - for avoiding the array key stroke(CSE) I have used index for lookup array only. And thanks for feedback, hppy to help you
Using an additional INDEX function to avoid array entry doesn't make the formula more efficient.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks