Suppose your data is in Sheet1 occupying A1:C55, and that you enter
the number into A2 of Sheet2. Put this in B2 of Sheet2:

=IF(A2<Sheet1!$A$1,"out of range",VLOOKUP(A2,Sheet1!$A$1:$C$55,3))

You might like to change "out of range" to "" to give a blank cell,
then copy this down as required.

Hope this helps.

Pete


On Sep 3, 6:32*am, jasonharris10
wrote:
I will try to explain this as well as I can. *I'm mediocre on excel, all self
taught so I'm just fumbling through this.

I have two sheets.

first sheet is the data

3 * * * * * 984 * * * * elephants
995 * * * 2458 * * * *lions
2459 * * 4325 * * * *tigers * * * * (and so on, for 55 different catagories)

Second sheet

Enter Number * * *Type
* * 1247 * * * * * * * lions
* * ????? * * * * * * * XXXX

I would like to be able to enter a number in that column (the spot where the
??? are) and the spreadsheet to be able to figure out what should go in XXXXX
spot.

How should I do this?

Thank you