What formula would I use? IF/MATCH
I am trying to put a formula together to say if there is a date, list it here (On-Site Training), if it says no match, then don't do anything.
Answers
-
Add IFERROR at the beginning of your formula. It should look something like this:
=IFERROR(INDEX({Range1}, MATCH(Column@row, {Range 2}), 0), "")
-
@Mike TV Looks like there might be a misplaced parenthesis there...
=IFERROR(INDEX({Range1}, MATCH(Column@row, {Range 2}, 0)), "")
-
@Mike TV @Paul Newcome I am still struggling. This is what I have so far: =IFERROR(INDEX({HQ Approved Training Date}, MATCH([HQ Approved Training Date]@row, {On-Site Training}), 0))
What I am trying to say is if HQ Approved Training Date is listed, then list it in On-Site Training.. if HQ Approved Training Date says #NO MATCH or is blank, don't do anything. The HQ Approved Training Date is pulling from another sheet.
-
The syntax is just a little off there at the end.
=IFERROR(INDEX({HQ Approved Training Date}, MATCH([HQ Approved Training Date]@row, {On-Site Training}, 0)), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!