Forum Discussion
Formula
Someone to help with a formulas i can use to transfer data from other sheet to one main sheet.
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)