mapping data from worksheet A to B based on ID

Marcus_230
NewLounger
Posts: 16
Joined: 04 Oct 2023, 14:49

mapping data from worksheet A to B based on ID

Post by Marcus_230 »

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.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: mapping data from worksheet A to B based on ID

Post by HansV »

Can you explain in detail what you want to do?
Best wishes,
Hans

Marcus_230
NewLounger
Posts: 16
Joined: 04 Oct 2023, 14:49

Re: mapping data from worksheet A to B based on ID

Post by Marcus_230 »

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.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: mapping data from worksheet A to B based on ID

Post by HansV »

In A2:

=IF(B2="","",VLOOKUP(B2,status_date!$A$2:$F$5000,6,FALSE))

Fill down to the last used row.
Best wishes,
Hans

Marcus_230
NewLounger
Posts: 16
Joined: 04 Oct 2023, 14:49

Re: mapping data from worksheet A to B based on ID

Post by Marcus_230 »

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?

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: mapping data from worksheet A to B based on ID

Post by HansV »

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.
Best wishes,
Hans

Marcus_230
NewLounger
Posts: 16
Joined: 04 Oct 2023, 14:49

Re: mapping data from worksheet A to B based on ID

Post by Marcus_230 »

Good morning Hans,

thank you very much. Very much appreciate it. Any recommendation on some online advanced Excel classes please?

M.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: mapping data from worksheet A to B based on ID

Post by HansV »

Best wishes,
Hans

Marcus_230
NewLounger
Posts: 16
Joined: 04 Oct 2023, 14:49

Re: mapping data from worksheet A to B based on ID

Post by Marcus_230 »

Thank you very much again. Very much appreciated.

M.