I need to make a combo box search field on a spreadsheet.
When i select a value (based on the A coloumn) from the combo box a value must return from the B coloumn.
Excel Help
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Excel Help
version of office?
Most people would sooner die than think; in fact, they do so - Bertrand Russel
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Excel Help
That would help
-
- Registered User
- Posts: 497
- Joined: 30 Apr 2007, 02:00
- Location: c:\program files\temp
- Contact:
Re: Excel Help
oops, it has to work on 2003
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Excel Help
Use Data validation lists in combination with Vlookup. It is easy and works wonderfully. PM me your email and I will send you an example. Or send me more details of what you are looking at doing.