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