a little help with finding and associating cells

[rcarrollct]

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....

 

[Anne Troy]

It's called VLOOKUP.
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Dave Peterson]

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.