Mapping date from a sheet.

[Marcus_230]

Hello,

I am trying to map a date from a sheet to another sheet based on ID. The first sheet Date missing! shows IDs in column A and it is grouped based on the external source. I am trying to map a date from sheet Date source! which is linked to the the IDs. Date should be only next to the IDs.
I am attaching sample workbook and as of now, I typed in the correct dates, so that it can be visible, what I am trying to accomplish.
Thank you.

M.

[gailb]

Try in B5 on the Date missing tab

=VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0)

Now copy and paste to the other cells in column B next to the ID's in column A

[Marcus_230]

Try in B5 on the Date missing tab

=VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0)

Now copy and paste to the other cells in column B next to the ID's in column A

I have tried that, but unfortunately, in the blanks, it shows #N/A. It needs to be blank, when no ID in column A. Attached.

[gailb]

Wrap it with IFERROR

=IFERROR(VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")

[Marcus_230]

Wrap it with IFERROR

=IFERROR(VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")

Yes, that worked. Is there also another way without the VLOOKUP? Such as IF with <>","?

[gailb]

Sure, try

=IF(A5<>"",VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")

[Marcus_230]

Sure, try

=IF(A5<>"",VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")

Yes, again, perfect.
Thank you very much. Very much appreciated.

[gailb]

You are welcome. Happy to help.

[Marcus_230]

I forgot to ask, what if the IDs are not sorted in ascending or descending order, but randomly? Would that be a problem with the VLOOKUP?

[HansV]

No, VLOOKUP with 0 or FALSE as 4th argument does not require the first column of the lookup range to be sorted.

[Marcus_230]

No, VLOOKUP with 0 or FALSE as 4th argument does not require the first column of the lookup range to be sorted.

Thank you very much for your explanation.
Best.