New Contributor

Someone to help with a formulas i can use to transfer data from other sheet to one main sheet.

3 Replies
Excel has plenty of functions to get this done but it's difficult to recommend one without knowing the arrangement of your data sets. Are you able to upload a sample workbook?
Am new on this platform. How do i upload the data set


Thank you for sending me the sample. Here is your formula for D2 (You may adjust the C100 as needed). Drag formula to E2 then fill down:


=VLOOKUP($B2,INDIRECT(SUBSTITUTE(D$1," ","")&"!B2:C100"),2,0)