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