About Vlook up function

jeffwongarrow

Dear All

I am trying to use a vlook up function which I believe joint tool will help, but somehow I am not about to sort it our smoothly.

Here is the original data from last week sample

Name	ID	Grade on 3 Nov	Grade on 27 Oct	Grade on 20 Oct
Company A	122622456	08	08	08
Company B	117349213	06	06	06
Company C	91422092	05	05	05
Company D	117339904	06	06	06
Company E	6417458	06	06	06

this is the data I want to look up with this week

Name	ID	Grade on 10 Nov	Grade on 3 Nov	Grade on 27 Oct	Grade on 20 Oct
Company A	122622456	08	[Null]	[Null]	[Null]
Company B	117349213	06	[Null]	[Null]	[Null]
Company C	91422092	05	[Null]	[Null]	[Null]
Company D	117339904	06	[Null]	[Null]	[Null]
Company E	6417458	06	[Null]	[Null]	[Null]

in this original file, I need to lookup up to beginning of 2020 with thousands of record by look up "ID", appreciate everyone help as always

atcodedog05

Hi @jeffwongarrow 

Hope this meets the requirement.

Here is a workflow for the task.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

vlookup_2.yxmd