Using a VLOOKUP sounds like what you need.

First, build an alphabetic table that includes all the possibilities
F G
1 Al 105
2 Bob 612
3 Carl 884
....

Then, write the following formula where you want the answer displayed:
=VLOOKUP(B3,F1:G12,2) [Which translates to Lookup B3 in the table that
is in F1 to G12, and pick the answer in the second column]


On Jan 17, 3:54 pm, MLee wrote:
Need a function to make a cell equal certain numeric values if another cell
has certain text...any solutions?

Example:

If cell A1 equals Tom then this cell should equal the value in cell D1, if
Greg this cell should equal the value in cell D2...ect.

I would like to be able to enter 12 critera all causing the cell to equal
the values in 12 other cells.