i have a spreadsheet and i want to move from coulmn g to columns m t x aa ac
if a product is in column g e,g if cell g8 equals paper then go to coulmn t8
or if cell g8 equals book then go to cell x8.
would i need to make a macro or is there a function that excel has that i
could use
thank you.