Vlookup/Join - bring back 3 seperate results if reference matches

[ashaw7]

Hey Community,

Hope you are well.

Struggling with the below situation which I assume has a very easy fix.

I have 2 data inputs which aren't the same format

Both data inputs have xrefs relating to orders.

What I'm trying to create a flow for is if - xref from (data set 1) is found in xref (data set 2) it brings back 3 values from (data set 2) e.g. Date - Time - Reference  - Results are brought back into a column of my selection.

I've tried Join and Find & replace and YouTube and cant seem to find an answer which relates to my situation.

appreciate any help you could provide

Thankyou

[Aaron_Harter]

Hi @ashaw7, 

You'll likely want to use the Join for these 3 new fields.  If you provide some sample data the community can provide a more specific answer, here's a sample workflow:

[ashaw7]

Hey Aaron,

Thanks for the quick response.

I have attached some sample data to provide a more specific answers.

I am trying to keep the same format as Data input 1 but If the reference from Data Input 1 is found in Data Input 2 it brings back the corresponding Date Time and REF  from Data Input 2 into Data Input 1 in the columns of my choice.

Hope this makes sense

Thankyou

[Jonathan-Sherman · Accepted solution]

Hi @ashaw7,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[ashaw7]

Hey Jonathan,

Thankyou for the solution

What was the benefit of unchecking the left and right boxes as this is where I went wrong

[Jonathan-Sherman]

Hi @ashaw7,

You need to uncheck the boxes from the left input as these are the "old" columns with no values in. We leave the right "new" columns in and simply rename them to be the same as the name as the "old" columns we've removed.

Regards,

Jonathan