mapping data from worksheet A to B based on ID

[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.

[HansV]

Can you explain in detail what you want to do?

[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.

[HansV]

In A2:

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

Fill down to the last used row.

[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?

[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.

[Marcus_230]

Good morning Hans,

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

M.

[HansV]

You might try Advanced Excel Full Course 2023

[Marcus_230]

Thank you very much again. Very much appreciated.

M.