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

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

Accepted answers

Jonathan-Sherman

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

20200429 - JoinData.yxzp

All comments

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:

2020-04-28 4.yxmd

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

Data input 2.xlsx

Data input 1.xlsx

Jonathan-Sherman

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

20200429 - JoinData.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703