Auto populate next cell depending on previous column

Hi Guys,

This is probably a really easy one, but I tried to google it and all I got were “SUM” formulas.

• I have summary table with 10 columns
• Cell reference of first column will always change (and is done manually)
• and the following 9 columns will the respective cells.

Example:

A2 = Sheet2!D100 (manually changed)
B2 = Sheet2!E100 (formula to get the info of same row, next column)
C2 = Sheet2!F100
D2 = Sheet2!G100
etc…

if A2 = Sheet2!A50
then B2 = A2 = Sheet2!B50


While I can just drag it over – is there a formula I can put into the 9 cells?

Without a sample file, it seems like using a =VLOOKUP function should work. If this doesn't work or if it's too confusing, please upload a sample file.

https://support.office.com/en-us/art...b-7257939faa65

Hi,

Thanks in advance, see attached 'example.xlsx'

this is a very basic version of what the actual reports look like.
The 'Table' is always in another worksheet with thousands of rows

realistically I can drag the formula over, but was hoping there would be a different way.

thanks again,