M
Mr. Smith
Hi.
I need to know what kind of function to use, to get the following
automation:
In column A a text like PROD1 are inserted.
Based on this text column B, C, D and E on the same row, retrives values
from a list where PROD1 are used as an lookup value.
The list are stored in another sheet like with column names like this:
Code Name Stock Sold Unitprice
PROD1 Envelopes 2400 1500 0,25
PROD2 Letter A4 5500 1500 0,10
I hope some of you understand what I need. And no, I can't use a database
this time due to client demands.
Just give me a hint to what I function I should look into, please.
Mr. Smith.
I need to know what kind of function to use, to get the following
automation:
In column A a text like PROD1 are inserted.
Based on this text column B, C, D and E on the same row, retrives values
from a list where PROD1 are used as an lookup value.
The list are stored in another sheet like with column names like this:
Code Name Stock Sold Unitprice
PROD1 Envelopes 2400 1500 0,25
PROD2 Letter A4 5500 1500 0,10
I hope some of you understand what I need. And no, I can't use a database
this time due to client demands.
Just give me a hint to what I function I should look into, please.
Mr. Smith.