Use the VLOOKUP function.
A tutorial can be found he

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dawn" wrote in message ...
|I am hoping that someone can help me out. I want to create a formula or
| function that will do basically this
|
| If I put a certain number into a cell (e6), then depending on what number I
| put in that cell the corresponding number will appear into another cell (f6).
|
| Basically ............. if I say 322 in e6, then 149 will appear in f6 or if
| I put 311 in e6, then 99 will appear in f6 and so on.
|
| Can someone please help me out??