Hello everyone.

The idea is to enter articles numbers in to column A and run macro which will show me in the same cells data taken from vlookup.
I wish to make a few buttons for few macros. Each macro will replace article number with different vlookup value.

Is it possible to get vlookup result for "lookup_value" placed in the same cell?


A1 = 12345678
after macro
A1 = vlookup(12345678,table_array,column,FALSE)

Any clue? I will try to customize it to my spreadsheet.

I really appreciate all the help you gave me.