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 t...
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)