How can I add OFFSET function to this formula?

[Peptide]

Hello,
I have the formula below in B21. If I want to cut/paste B21 to C21, D21 etc, how can I add the OFFSET function so it adjusts automatically?

The area 'UPLOAD FILE'!G2 obviously pulls from the G2 cell of the UPLOAD FILE. When I copy B21 top C21 I need the G2 to change to G3


Cell B21
=IFERROR(VLOOKUP(OFFSET('UPLOAD FILE'!G2,COLUMN()-2,0),'Pricing Table'!$BH$5:$BT$36,MATCH('UPLOAD FILE'!E2,'Pricing Table'!$BH$3:$BT$3,0),FALSE)*B5,"Value For Purity and Mgs Combo Not Found On Base Price Data Table")

Cell C21
=IFERROR(VLOOKUP(OFFSET('UPLOAD FILE'!G3,COLUMN()-2,0),'Pricing Table'!$BH$5:$BT$36,MATCH('UPLOAD FILE'!E2,'Pricing Table'!$BH$3:$BT$3,0),FALSE)*B5,"Value For Purity and Mgs Combo Not Found On Base Price Data Table")

Cell B21
=IFERROR(VLOOKUP(OFFSET('UPLOAD FILE'!G4,COLUMN()-2,0),'Pricing Table'!$BH$5:$BT$36,MATCH('UPLOAD FILE'!E2,'Pricing Table'!$BH$3:$BT$3,0),FALSE)*B5,"Value For Purity and Mgs Combo Not Found On Base Price Data Table")

 

[StephenCrump]

Assuming your starting formula is:

B21: =IFERROR(VLOOKUP('UPLOAD FILE'!G2,'Pricing Table'!$BH$5:$BT$36,MATCH('UPLOAD FILE'!$E2,'Pricing Table'!$BH$3:$BT$3,0),FALSE)*$B5,"Value For Purity and Mgs Combo Not Found On Base Price Data Table")

and you want G2 to change to G3, G4 .... to G10, say, then change this formula to:

=IFERROR(VLOOKUP(INDEX('UPLOAD FILE'!$G2:$G10,COLUMNS($B21:B21)),'Pricing Table'!$BH$5:$BT$36,MATCH('UPLOAD FILE'!$E2,'Pricing Table'!$BH$3:$BT$3,0),FALSE)*$B5,"Value For Purity and Mgs Combo Not Found On Base Price Data Table")

 

[Peptide]

This works great! Thank you Stephen!

 

[StephenCrump]

You're welcome.