Help with Date Formula

WinaHath

I need help with this formula, please.

I need to get the PO date from this sheet

and output that date to this sheet

I tried this formula but it is not working:

=IFERROR(INDEX({PO Date}, MATCH([Vendor Name]@row, {Vendor ID#}, 1)), "")

Both columns are Date fields

Thank you!😀

Nick Korna

Hi @WinaHath,

Your formula makes it look like you're trying to match the Vendor Name with the ID # on the other sheet. Should your formula be more along the lines of something like this?

=IFERROR(INDEX({PO Date}, MATCH([Vendor ID #]@row, {Vendor ID#}, 1)), "")