Excel - Join (vlookup) from same column

[Baz123]

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.

[Qiu]

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

[flying008]

Hi, @Baz123 

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

[Baz123]

Hi @flying008 ,

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

It looks to be a simple fix.

Thanks.

[flying008 · Accepted solution]

Hi, @Baz123 

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

[binuacs]

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

[Baz123]

Hi @flying008 

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

:)