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

Word VBA - Automatic change content of a cell in table using dropdown list 5
Creating a Chart on form from selected data in query. 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Excel does not accept text format! 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Printed Material Missing Fill Color 3
Pulling Multiple Text Strings in a One Cell 4
XIRR 1

Top