ExcelBanter - Data entered from list automatically enters number in another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data entered from list automatically enters number in another cell (https://www.excelbanter.com/excel-worksheet-functions/256838-data-entered-list-automatically-enters-number-another-cell.html)

Data entered from list automatically enters number in another cell

I am using Excel 2007 and here is an simplified example of what I need.

Items Price

Potatoes 4.35
Apples 5.55
Oranges 7.95
Onions 4.55
Carrots 3.75

Items Column is List for Valid entries in table below

Prices are the numbers I want entered when I enter the Item

If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16

Example of table I want:

My Entries: Excel Enters

A16 Carrots D16 3.75
A17 Oranges D17 7.95
A18 Onions D18 4.55
A19 Onions D19 4.55
A20 Potatoes D20 4.35

Thanks so much for your help !

Data entered from list automatically enters number in anothercell

Put this in D16:

=VLOOKUP(A16,A$2:B$6,2,0)

then copy down.

If you want it a bit more robust, then you will need something like
this:

=IF(A16="","",IF(ISNA(VLOOKUP(A16,A$2:B$6,2,0)),"" ,VLOOKUP(A16,A$2:B
$6,2,0)))

Hope this helps.

Pete

On Feb 19, 5:31*pm, gbryce wrote:
I am using Excel 2007 *and here is an simplified example of what I need..

* * Items * * * * Price

Potatoes * * * *4.35
Apples * * * * *5.55
Oranges * * * *7.95
Onions * * * * *4.55
Carrots * * * * 3.75

Items Column is List for Valid entries in table below

Prices are the numbers I want entered when I enter the Item

If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16

Example of table I want:

My Entries: * * * * * * * *Excel Enters

A16 Carrots * * * * * * * D16 *3.75
A17 Oranges * * * * * * *D17 *7.95
A18 Onions * * * * * * * *D18 *4.55
A19 Onions * * * * * * * *D19 *4.55
A20 Potatoes * * * * * * *D20 *4.35

Thanks so much for your help !

Data entered from list automatically enters number in another cell

Take a look VLOOKUP function in help menu

"gbryce" wrote:

I am using Excel 2007 and here is an simplified example of what I need.

Items Price

Potatoes 4.35
Apples 5.55
Oranges 7.95
Onions 4.55
Carrots 3.75

Items Column is List for Valid entries in table below

Prices are the numbers I want entered when I enter the Item

If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16

Example of table I want:

My Entries: Excel Enters

A16 Carrots D16 3.75
A17 Oranges D17 7.95
A18 Onions D18 4.55
A19 Onions D19 4.55
A20 Potatoes D20 4.35

Thanks so much for your help !

Data entered from list automatically enters number in another

I had never used VLOOKUP function before but now I am beginning to understand
how it works. It is exactly what I was needing. Thanks Guys.

"Pete_UK" wrote:

Put this in D16:

=VLOOKUP(A16,A$2:B$6,2,0)

then copy down.

If you want it a bit more robust, then you will need something like
this:

=IF(A16="","",IF(ISNA(VLOOKUP(A16,A$2:B$6,2,0)),"" ,VLOOKUP(A16,A$2:B
$6,2,0)))

Hope this helps.

Pete

On Feb 19, 5:31 pm, gbryce wrote:
I am using Excel 2007 and here is an simplified example of what I need..

Items Price

Potatoes 4.35
Apples 5.55
Oranges 7.95
Onions 4.55
Carrots 3.75

Items Column is List for Valid entries in table below

Prices are the numbers I want entered when I enter the Item

If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16

Example of table I want:

My Entries: Excel Enters

A16 Carrots D16 3.75
A17 Oranges D17 7.95
A18 Onions D18 4.55
A19 Onions D19 4.55
A20 Potatoes D20 4.35

Thanks so much for your help !

.

Data entered from list automatically enters number in another

You're welcome - thanks for feeding back.

Pete

On Feb 19, 10:40*pm, gbryce wrote:
I had never used VLOOKUP function before but now I am beginning to understand
how it works. It is exactly what I was needing. Thanks Guys.

"Pete_UK" wrote:
Put this in D16:

=VLOOKUP(A16,A$2:B$6,2,0)

then copy down.

If you want it a bit more robust, then you will need something like
this:

=IF(A16="","",IF(ISNA(VLOOKUP(A16,A$2:B$6,2,0)),"" ,VLOOKUP(A16,A$2:B
$6,2,0)))

Hope this helps.

Pete

On Feb 19, 5:31 pm, gbryce wrote:
I am using Excel 2007 *and here is an simplified example of what I need..

* * Items * * * * Price

Potatoes * * * *4.35
Apples * * * * *5.55
Oranges * * * *7.95
Onions * * * * *4.55
Carrots * * * * 3.75

Items Column is List for Valid entries in table below

Prices are the numbers I want entered when I enter the Item

If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16

Example of table I want:

My Entries: * * * * * * * *Excel Enters

A16 Carrots * * * * * * * D16 *3.75
A17 Oranges * * * * * * *D17 *7.95
A18 Onions * * * * * * * *D18 *4.55
A19 Onions * * * * * * * *D19 *4.55
A20 Potatoes * * * * * * *D20 *4.35

Thanks so much for your help !

.- Hide quoted text -

- Show quoted text -