If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting Information
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 |
#2
|
|||
|
|||
Sorting Information
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(A2Sheet1!$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 |
Thread Tools | |
Display Modes | |
|
|