Sorting Information

[jasonharris10]

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

 

[Pete_UK]

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