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.
Mapping date from a sheet.
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Mapping date from a sheet.
You do not have the required permissions to view the files attached to this post.
-
- 3StarLounger
- Posts: 256
- Joined: 09 May 2020, 14:00
Re: Mapping date from a sheet.
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
=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
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Re: Mapping date from a sheet.
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.
You do not have the required permissions to view the files attached to this post.
-
- 3StarLounger
- Posts: 256
- Joined: 09 May 2020, 14:00
Re: Mapping date from a sheet.
Wrap it with IFERROR
=IFERROR(VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")
=IFERROR(VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
-
- 3StarLounger
- Posts: 256
- Joined: 09 May 2020, 14:00
Re: Mapping date from a sheet.
Sure, try
=IF(A5<>"",VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")
=IF(A5<>"",VLOOKUP(A5,'Date Source'!$A$5:$B$21,2,0),"")
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
-
- 3StarLounger
- Posts: 256
- Joined: 09 May 2020, 14:00
Re: Mapping date from a sheet.
You are welcome. Happy to help.
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Re: Mapping date from a sheet.
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?
-
- Administrator
- Posts: 79526
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Mapping date from a sheet.
No, VLOOKUP with 0 or FALSE as 4th argument does not require the first column of the lookup range to be sorted.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49