if / then formulas (conditional?)

I would like to write a formula that would recognize a numeric value in a given cell and display another numeric value that is linked to (or associated with) it in the formula cell.  for example:  let's say #1 = 75, 2 = 136, 3=98, and so on, up to #250 = whatever.  Is there a formula that would recognize the number 1, or 2, or 3, etc. in a column of cells and display its associated value in another column of cells?

Another example:  If I type "1" in cell a-1 then cell b-1 displays the number "75".  If I change a-1 to "2" then b-1 displays "136".  I need to be able to assign totally arbitrary values to the numbers 1 thru 250 and have those values show up in my formula cells.  Once I do this for a-1 and b-1 I should be able to repeat it on down the rows or in columns to the right of a and b.

Hope this makes sense.  i would appreciate any advice.

Floodzone

As you have so many conditions I would use a separate table and a Vlookup formula, so image you have a table on Sheet2 covering A1:B250, with the values 1-250 in A1:A250 and the associated 'arbitrary values' in B1:B250, then on sheet1 in B1 type

=VLOOKUP(A1,Sheet2!$A$1:$B$250,2,FALSE)

This will leave you with N/A# in B1 until you enter a 'matching' value from the list in Sheet2, to overcome that, just add an error checking routine.

=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$B$250,2,FALSE)),"",VLOOKUP(A1,Sheet2!$A$1:$B$250,2,FALSE))

 Regarding your random number generation, in cell reference B1 to B250 (or whatever number is your last number), enter the following formula: =ROUND(RAND()*250,0)

If you press the F9 key, it should change automatically, whatever values you enter in column A.

 Instead of using the redundant IsError() paste

Public Function ifError(ByRef ToEvaluate As Variant, Optional Default As Variant = 0) As Variant

    If isError(ToEvaluate) Then
        ifError = Default
    Else
        ifError = ToEvaluate
    End If
   
End Function

into your VBE then use a much abbreviated formula that Nick gave like

=IfError(VLOOKUP(A1,Sheet2$A$1:$B$250,2,FALSE),"")

Or for completeness if you have Excel 2007 use the built-in IFERROR function

=IFERROR(VLOOKUP(A1,Sheet2$A$1:$B$250,2,FALSE),"")

thanks all,

let me take some time to see if I can make any of those ideas work.  I appreciate the help.

Okay got it to work with vlookup.  Thank you all very much