2 criteria for a VLookup

I have two sheets, 1 pipeline 2 install bookings.

On the install bookings sheet there is a job number column and a install status column

I have done a VLOOKUP in the pipeline that searches in the Install bookings for the matching row job number and returns the install status for that job number.

=IFERROR(VLOOKUP([Pronto JN:]@row, {Install Req JN}, 2, false), "")

however there may be times that 2 or more install bookings are made against a specific job number. I would like to figure out how to have the install status returned for the most recent entry in the install bookings for a particular job number.

I don't know if this can be done using MAX and a date column or auto numbering the entries and using LARGE to find the matching PO and the largest number? cant seem to figure it out

not sure if this makes sense, hopefully it does

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!