list and autocomplete help for a newbie please?

ocoste

New Member
Joined
Dec 10, 2006
Messages
4
Hi All,
Any help with the following is appreciated.
I'm using excel for purposes of an IT asset audit. I want to set it up so that when entering make/model of a computer i.e. Dell, the entries of 'destop' and 'workstation' are entered in adjacent columns automatically. Also, is it possible to have validation data lists on a different workbook from the actve sheet and have these linked in some way. Hope this makes sense and someone can help.
Thanks,
Steve
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

For the first question, how is Excel supposed to know whether it should be "desktop" or "workstation"?

You might want to check out Aladin Akyurek's post on Dependent Lists.

For the second you can have a dedicated "list" sheet. Just create a list and name it (Insert-->Name-->Define), then you can use Data-->Validation-->Allow-->List-->Source-->=YourListName.

Hope that helps,

Smitty
 

ocoste

New Member
Joined
Dec 10, 2006
Messages
4
Smitty

Thanks for your reply. I get the point you made and I guess I have not explained my query correctly. The sheet has column headings:
Make Product Cat. Generic Cat. Version

So, a Dell Optiplex is a desktop but ALSO a workstation in the generic category. It may not be possible but I was trying to reduce data entry by keyboard and 'link' dell to desktop to workstation etc. I hope this makes sense?

Thanks
 

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,166
Is Dell the only word wish you which to link....

Do you mean an IF statement: (Although Smitty probably has a better way)

Something like if A1 is Dell then B1 shows desktop and C1 shows workstation.....?

=IF(A1="Dell","Desktop","") put where desktop should go
=IF(A1="Dell","Workstation","") put where workstation would go?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,575
Members
414,390
Latest member
plimbu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top