| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
a little help with finding and associating cells
ok so here is my dilemma, I need a formula that will look at a cell value on one work sheet, check for the same value on another work sheet in a defined column, and insert a coresponding value from another column...... is that even remotely possible??? any help would be greatly appreciated.... -- rcarrollct ------------------------------------------------------------------------ rcarrollct's Profile: http://www.excelforum.com/member.php...o&userid=24931 View this thread: http://www.excelforum.com/showthread...hreadid=384671 |
|
#2
|
|||
|
|||
|
It's called VLOOKUP.
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "rcarrollct" wrote in message ... ok so here is my dilemma, I need a formula that will look at a cell value on one work sheet, check for the same value on another work sheet in a defined column, and insert a coresponding value from another column...... is that even remotely possible??? any help would be greatly appreciated.... -- rcarrollct ------------------------------------------------------------------------ rcarrollct's Profile: http://www.excelforum.com/member.php...o&userid=24931 View this thread: http://www.excelforum.com/showthread...hreadid=384671 |
|
#3
|
|||
|
|||
|
It sounds like =vlookup() or =index(match()) would be a good choice (depending
on how your data is laid out). Visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. rcarrollct wrote: ok so here is my dilemma, I need a formula that will look at a cell value on one work sheet, check for the same value on another work sheet in a defined column, and insert a coresponding value from another column...... is that even remotely possible??? any help would be greatly appreciated.... -- rcarrollct ------------------------------------------------------------------------ rcarrollct's Profile: http://www.excelforum.com/member.php...o&userid=24931 View this thread: http://www.excelforum.com/showthread...hreadid=384671 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
