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.