2 criteria for a VLookup

Sian.G

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

Paul Newcome

How are new entries being made on the first sheet?

Sian.G

Hey Paul,

The Pipeline they get entered manually, the install bookings is filled out using a form.

Paul Newcome

My suggestion would be to insert an auto-number column and sort the sheet in descending order so that most recent entries are at the top of the sheet. Then set your form to populate at the top of the sheet to keep new entries populating.

Since the formula pulls the value from the first match, having new entries made at the top of the sheet means your most recent entry will be your first match.