Excel - Join (vlookup) from same column

Hi,

Bit of a weird one to ask, so bear with me

We have a data set that is imported and work flowed. At the end of the workflow the data looks like this:

Record	Supplier	Purchaser	PO Number	Location
1	A	NULL	20714	BBBB
2	A	Bob S	21677	BBBB
3	B	NULL	21655	EEEE
4	B	NULL	21655	EEEE
5	B	Mary Y	21341	EEEE
6	B	NULL	21342	EEEE
7	A	NULL	21678	BBBB

We can see from the table above there are NULLs in Purchaser. Using columns Supplier and Location we can see that record 2 should be Bob, and records 3, 4, and 6 should belong to Mary.

Is it possible / how does one then use the current data set to fill in the NULLs? I have tried filtering the dataset, then joining (vlookup) on the original data set but this does not work.

Any suggestions?

Thanks.

Datasets

Join

Accepted answers

If your supplier have N purchasers in location xxx. you can Join Supplier&Location as new filed to match.

All comments

@Baz123
We can seperate the records with Purchaser as Null then join with those are not withe key of 'Supplier' and "Location".

0919-Baz123.yxmd

I assume your Supplier has only 1 Purchaser in Location xxx.

录制_2022_09_19_10_21_45_725.gif

Hi @flying008 ,

Can you post the workflow so I can see the config?

It looks to be a simple fix.

Thanks.

If your supplier have N purchasers in location xxx. you can Join Supplier&Location as new filed to match.

@Baz123 Another way of doing this with the Multi-Row tool

Multi-Row_0919.yxmd

Your solution worked great. I had to tweak it slightly to work in the real data, but it sorted the issue.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703