Forum Discussion
Trying to bring the data
Hi
I am trying to populate the cell values in sheet 1, how can i do this i am working on data with more than 10000.
My question: I have a data worksheet and sheet 1 in the attached file. If the cell value in column A from sheet 1 is equals to column A in data worksheet. I want the respective fields to populate using formula. How can I get this done.
1 Reply
In B2 on Sheet1:
=INDEX(data!$B$2:$BH$296,MATCH($A2,data!$A$2:$A$296,0),MATCH(B$1,data!$B$1:$BH$1,0))
Adjust the ranges if necessary.
Fill to the right, then down (or vice versa)
