I need to use a unique identifier from sheet 1, look it up in sheet two and then copy over data from specific columns of sheet two to sheet one

Help StudioX
,
1

Hi, I’m currently using studiox to build an automation which -

1.Filters sheet 2 with unique identifier from sheet 1
2.Copies different columns data from sheet 2 onto sheet 1
3.After finishing, it needs to go to the second unique identifier and repeat the copy paste.

Which functions would you use to complete this?

2

@sk3886

Please try using look up formula in excel…that would do it directly…

You can use write cell /write formula and auto fill range to fill the formula

Cheers

3

Are you suggesting not to use StudioX for this?

4

@sk3886

You can use studiox but not to do these manipulations…rather to use lookup formula to be populated using studiox to the target file

Cheers