Linking Data

[bkverma]

Hi, I have a sheet 1 of data which has 8 columns. The data in the 7 columns(B to G) is dependent on the data in the first column(say A).

I have a master sheet 2 where I would like to link this data. In sense, that when I select a particular cell(in Sheet 2) to make it dependent on Cell in Column A of sheet 1, the other columns in Sheet 2 should get corresponding data(Column B to G) of sheet 1.  

[#2]

@bkverma Without looking at your data, I suggest you can use VLOOKUP function for your problem.

If you can share the file, I can help further.

[#3]

Hi @bkverma 

I believe this could be solved using XLOOKUP, VLOOKUP, or INDEX & MATCH.

Since I don't have your data sample, I have used sample information which I believe is something close to what you wanted. I used both VLOOKUP&MATCH as well as INDEX & MATCH.

For VLOOKUP, the formula was

=VLOOKUP($A4,Data,MATCH(Sheet2!B$2,Data[#Headers],0))

While INDEX&MATCH used the following;

=INDEX(Data,MATCH($A11,Data[[ProductLabel]:[ProductLabel]],0),MATCH(Sheet2!B$9,Data[#Headers],0))

You can make a selection using cells A4 and A11 on sheet 2 to see the changes.

Let me know if this is what you wanted.

Cheers.