I have a price list and want to set something up, so that when I type a code
of a product in, it will automatically bring up the price.
So for example I type in A1234, I want it to automatically bring up the
price from price list on another sheet (the sheet is in the same workbook).
It doesn't matter if the price shows in the same cell or a different cell.
Is there anyway that I can do this?

Bonny,
If I understand what you wish to do, I believe that you can do it by first
setting up a table of the product codes with their prices, in a separate part
of the worksheet, or more safely on a separate tab/worksheet within the
spreadsheet file.

Create a new tab, call it something that makes sense to you, such as Price
Lookup, or Product Prices. Create a table with product code in the left-most
column and price in another column (you could store other product info in
this table too). Sort the table in Ascending Order by Product Code.

Back on the tab where you wish to automatically bring up the price, use the
vlookup function. Place this function in the product price column. In the
function the first parameter/argument will be to point at the column where
you've entered the product code. The next argument in the function will be
the array of values in the table you created on the other tab. Make sure the
address is absolute, not relative. The final argument will be a number to
indicate the column in which the price appears... for example, if the table
is just two columns, code 1st and price 2nd, put the number 2 here to
indicate that the value you want to lookup is in the 2nd column.

Let me know if that doesn't work, or if my instructions are unclear. Good
luck!

"Bonny" wrote:

I have a price list and want to set something up, so that when I type a code
of a product in, it will automatically bring up the price.
So for example I type in A1234, I want it to automatically bring up the
price from price list on another sheet (the sheet is in the same workbook).
It doesn't matter if the price shows in the same cell or a different cell.
Is there anyway that I can do this?

Excellent! that is exactly what I was looking for. I appreciate it. That has
been driving me nuts.

"Mikedaspike" wrote:

Bonny,
If I understand what you wish to do, I believe that you can do it by first
setting up a table of the product codes with their prices, in a separate part
of the worksheet, or more safely on a separate tab/worksheet within the
spreadsheet file.

Create a new tab, call it something that makes sense to you, such as Price
Lookup, or Product Prices. Create a table with product code in the left-most
column and price in another column (you could store other product info in
this table too). Sort the table in Ascending Order by Product Code.

Back on the tab where you wish to automatically bring up the price, use the
vlookup function. Place this function in the product price column. In the
function the first parameter/argument will be to point at the column where
you've entered the product code. The next argument in the function will be
the array of values in the table you created on the other tab. Make sure the
address is absolute, not relative. The final argument will be a number to
indicate the column in which the price appears... for example, if the table
is just two columns, code 1st and price 2nd, put the number 2 here to
indicate that the value you want to lookup is in the 2nd column.

Let me know if that doesn't work, or if my instructions are unclear. Good
luck!

"Bonny" wrote:

I have a price list and want to set something up, so that when I type a code
of a product in, it will automatically bring up the price.
So for example I type in A1234, I want it to automatically bring up the
price from price list on another sheet (the sheet is in the same workbook).
It doesn't matter if the price shows in the same cell or a different cell.
Is there anyway that I can do this?