Hi all.
Probably a very simple question. Have an order form, that needs the following.
On sheet 1. In column A (called ItemNumber), I have the item numbers. In column B (called ItemName), I have the item names.
On sheet 2. I have a data validation list in column A, that refers to ItemName from sheet 1.
What I want, is to return the value from sheet 1 column B in sheet 2 column B. When I select an ItemName from the list.
Cheers
Probably a very simple question. Have an order form, that needs the following.
On sheet 1. In column A (called ItemNumber), I have the item numbers. In column B (called ItemName), I have the item names.
On sheet 2. I have a data validation list in column A, that refers to ItemName from sheet 1.
What I want, is to return the value from sheet 1 column B in sheet 2 column B. When I select an ItemName from the list.
Cheers