Return a date from a row, on a different sheet, that corresponds with their name.

Paul Mangan

I have a sheet that I am trying to inform team members when their license expires and I am wanting a formula that looks at one sheet, if the name is there it return the corresponding value. I can get the formula to return yes or no but I need the exact date.

=IFERROR(IF(AND(MATCH($Name@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, $Name@row, {Pallet Jack}, <>"") > 0), "Yes", "No"), "Error")

This is the formula I started with.

Paul Mangan

=IFERROR(IF(AND(MATCH($Name@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, $Name@row, {Pallet Jack}, <>"") > 0), {Pallet Jack}, "No"), "Error")

I tried this formula, which is saying to return that value in that column and it is returning #DATE EXPECTED on the people who have dates, and "No" on the cells that are blank and don't have anything.

KPH

Hi @Paul Mangan

Have you tried an INDEX MATCH formula?

I can't see your sheets (I am guessing Pallet Jack is the date) but the formula will be something like

=INDEX({Pallet Jack}, MATCH($Name@row,{Team Member}, 0))