Formula

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

@chall2305 

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)