Hello all,
I have been trying to map dates from one worksheet to another based on unique ID leaving blank rows; only match with ID where applicable.
If anyone has a suggestions?
Thank you.
M.
mapping data from worksheet A to B based on ID
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
mapping data from worksheet A to B based on ID
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 79521
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: mapping data from worksheet A to B based on ID
Can you explain in detail what you want to do?
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Re: mapping data from worksheet A to B based on ID
I have dates in status_date worksheet column F and trying to have these dates in raw_data worksheet in column A next to the ID, which is in column B.
I apologize for not being specific. Please see a scrennshot.
I apologize for not being specific. Please see a scrennshot.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 79521
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: mapping data from worksheet A to B based on ID
In A2:
=IF(B2="","",VLOOKUP(B2,status_date!$A$2:$F$5000,6,FALSE))
Fill down to the last used row.
=IF(B2="","",VLOOKUP(B2,status_date!$A$2:$F$5000,6,FALSE))
Fill down to the last used row.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Re: mapping data from worksheet A to B based on ID
That is great, but what if the Status date is not i column F6 (VLOOKUP 6), but column 18? Is there a limit for VLOOKUP column?
-
- Administrator
- Posts: 79521
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: mapping data from worksheet A to B based on ID
No, it could be column 16000 if necessary.
If you have Microsoft 365 or Office 2021, you can also use
=IF(B2="","",XLOOKUP(B2,status_date!$A$2:$A$5000,status_date!$F$2:$F$5000,""))
And you can change the range references as needed.
If you have Microsoft 365 or Office 2021, you can also use
=IF(B2="","",XLOOKUP(B2,status_date!$A$2:$A$5000,status_date!$F$2:$F$5000,""))
And you can change the range references as needed.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Re: mapping data from worksheet A to B based on ID
Good morning Hans,
thank you very much. Very much appreciate it. Any recommendation on some online advanced Excel classes please?
M.
thank you very much. Very much appreciate it. Any recommendation on some online advanced Excel classes please?
M.
-
- Administrator
- Posts: 79521
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: mapping data from worksheet A to B based on ID
You might try Advanced Excel Full Course 2023
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 37
- Joined: 04 Oct 2023, 14:49
Re: mapping data from worksheet A to B based on ID
Thank you very much again. Very much appreciated.
M.
M.