G Guest Apr 13, 2006 #1 How do I retreive data, which I've entered, from another worksheet when I enter a code or # that is specific to that data?
How do I retreive data, which I've entered, from another worksheet when I enter a code or # that is specific to that data?
P Peo Sjobom Apr 13, 2006 #2 Assuming you have a yable and the data is set up like code1 value value etc code2 value value etc and so on then you can use =VLOOKUP(C1,Sheet2!A2:C50,2,0) where C1 is the typed in lookup value (code) and A2:C50 the table and this particular formula will return the value from column 2 lookup VLOOKUP in help -- Regards, Peo Sjoblom Nothwest Excel Solutions www.nwexcelsolutions.com remove ^^ from email "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey
Assuming you have a yable and the data is set up like code1 value value etc code2 value value etc and so on then you can use =VLOOKUP(C1,Sheet2!A2:C50,2,0) where C1 is the typed in lookup value (code) and A2:C50 the table and this particular formula will return the value from column 2 lookup VLOOKUP in help -- Regards, Peo Sjoblom Nothwest Excel Solutions www.nwexcelsolutions.com remove ^^ from email "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey
M Max Apr 13, 2006 #3 creo said: How do I retreive data, which I've entered, from another worksheet when I enter a code or # that is specific to that data? Click to expand... Try Debra's pages for 2 ways: http://www.contextures.com/xlFunctions02.html (VLOOKUP) http://www.contextures.com/xlFunctions03.html (INDEX/MATCH) ---
creo said: How do I retreive data, which I've entered, from another worksheet when I enter a code or # that is specific to that data? Click to expand... Try Debra's pages for 2 ways: http://www.contextures.com/xlFunctions02.html (VLOOKUP) http://www.contextures.com/xlFunctions03.html (INDEX/MATCH) ---
