What formula would I use? IF/MATCH

haley brianne

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.

Screenshot 2022-12-19 at 11.33.53 AM.png

Uploaded Dec 19, 202229.39 KB

Mike TV

@haley brianne

Add IFERROR at the beginning of your formula. It should look something like this:

=IFERROR(INDEX({Range1}, MATCH(Column@row, {Range 2}), 0), "")

Paul Newcome

@Mike TV Looks like there might be a misplaced parenthesis there...

=IFERROR(INDEX({Range1}, MATCH(Column@row, {Range 2}, 0)), "")

haley brianne

@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.

Paul Newcome

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)), "")