| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on lookups
Hi can anyone help please.
I am building an order form I have put Validation lists in a number of columns, and I want to atomaticly ad in a product code from another list, given the data selected in the other columns, can this be done? Thanks in advance. Colin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help on lookups
Colin,
Have a look at this excellent site: http://www.contextures.com/xlDataVal11.html "Colin" wrote: Hi can anyone help please. I am building an order form I have put Validation lists in a number of columns, and I want to atomaticly ad in a product code from another list, given the data selected in the other columns, can this be done? Thanks in advance. Colin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help on lookups
Hi Colin,
Vlookup would seem to do what you want. =VLOOKUP(F1,$J$1:$K$5,2,0) Where F1 is the dropdown with the item, J1:J5 is a list of the items in the dropdown and K1:K5 are the associated product codes for the items. HTH Regards, Howard "Colin" wrote in message ... Hi can anyone help please. I am building an order form I have put Validation lists in a number of columns, and I want to atomaticly ad in a product code from another list, given the data selected in the other columns, can this be done? Thanks in advance. Colin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAN DATES BE USED IN LOOKUPS? | Excel Discussion (Misc queries) | |||
| Converging two lookups? (would save me AEONS of time!) | Excel Worksheet Functions | |||
| Q: Using lookups to normalize a database? | Excel Discussion (Misc queries) | |||
| External lookups won't load | Excel Discussion (Misc queries) | |||
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Linear Mode
