ExcelBanter - Alphabetical Code and matching data to a new worksheet

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Alphabetical Code and matching data to a new worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/145167-alphabetical-code-matching-data-new-worksheet.html)

mda19652

Alphabetical Code and matching data to a new worksheet

In the new cell, I want to type in an alphabetical letter to list possible
food codes and also other data related to this code, eg Description, Unit and
Price/Unit, and to be able to select whichever one I want.

eg. Worksheet with data

A4 D4 E4 F4
Code Description Unit Price/Unit
OLMA001 Olives, Manzanillo kg $25.20

I am having difficulty writing up a formula for this.

Many thanks,
Marty

Teethless mama

Alphabetical Code and matching data to a new worksheet

Take a VLOOKUP function in Help menu

"mda19652" wrote:

In the new cell, I want to type in an alphabetical letter to list possible
food codes and also other data related to this code, eg Description, Unit and
Price/Unit, and to be able to select whichever one I want.

eg. Worksheet with data

A4 D4 E4 F4
Code Description Unit Price/Unit
OLMA001 Olives, Manzanillo kg $25.20

I am having difficulty writing up a formula for this.

Many thanks,
Marty

All times are GMT +1. The time now is 07:15 AM.