linking cells

S

stremetzky

On sheet1 I have the following data:

A B
111 NAME_1
222 NAME_2
333 NAME_3
444 NAME_4
.... ...

On sheet2 I'd like to link certain cells so that when I write in one
cell »111«, for example, I want in the cell beside to appear NAME_1.

Tnx for help,
stremetzky
 
A

Anne Troy

It's called VLOOKUP and I've an article on it here:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
On sheet1 I have the following data:

A B
111 NAME_1
222 NAME_2
333 NAME_3
444 NAME_4
.... ...

On sheet2 I'd like to link certain cells so that when I write in one
cell »111«, for example, I want in the cell beside to appear NAME_1.

Tnx for help,
stremetzky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index and matching with string search! 4
Only matach two excel spread sheet 2
Compare cells in different worksheets 3
OFFSET equation not working 3
Combine two sets of overlapping Date/Time data into 3 columns. 3
Combing 2 lists of data 2
autocomplete from specific list 8
excel graphic planner 2

Top