Jul 26 2022 06:25 AM
Someone to help with a formulas i can use to transfer data from other sheet to one main sheet.
Jul 26 2022 06:29 AM
Jul 26 2022 08:39 AM - edited Jul 27 2022 04:43 AM
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)