fill in text from another cell

G

Godspeed

I am working on an inventory of equipment, and have a dropdown for the make
of equipment, and would like to have the model cell populate with the model
number of the peice of equipment automaticly, i.e. if the make is "chair"
then the model is "P1234". all the "makes" have only one model number to
them, i have 5 differant makes so only 5 differant models. any help would be
great.
 
S

Sheeloo

Assumption:
1. You have make dropdown in A1 and you want the model in B1 of Sheet1.
2. You have 'make' in A1-A5 of sheet2 and 'model' in B1-B5
Enter this in B1 of Sheet1
=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,False),"",VLOOKUP(A1,Sheet2!A:B,2,False))
 

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

Printed Material Missing Fill Color 6
Auto Populate Data from cell to another sell in differant sheets 5
Creating an order form from a model number 2
Data Validation Question 1
Pulling Multiple Text Strings in a One Cell 4
Acoustics - 80Hz loss in car! 0
EXCEL PROJECT HELP!! 3
Another most-recent date query 0

Top