Alphabetical Code and matching data to a new worksheet

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using one worksheet to pull data from many 1
Discount to Client 1
Automatically extract only relevant data from a worksheet into a new one? 3
How to insert new worksheet based on # of rows in a data sourch 2
How do I allow users to make a choice in a worksheet? 2
How to update a column making sure new rows are created for new va 2
copy data from worksheet in folder a to worksheet in folder b 6
userform copy data to more than one location 5

Top