HELP ON VLOOKUP
Niek, can you explain in simpler terms? I am not sure I followed what you said.
"Niek Otten" wrote:
Hi Bonnie,
Concatenate the Product name and Item#, both in the lookup table and in the search argument
Concatenation can be done with the "&" operator or with the CONCATENATE() function
Post again in this thread if you can't get it done
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Bonnie" wrote in message ...
| I have made a form and inserted VLookups. In my list of products there is
| more than one of that product name but different sizes. So it looks like this:
|
| Product name Item # Discription Unit of measure
| Buccaneer Plus #00521 2x2.5ga ju ga
| Buccaneer Plus #00522 30ga drum ga
| Buccaneer Plus #00523 Bulk ga ga
|
| So then I made a drop down list from the product name and everything else
| fills in itself because of the vlookups I put in.
|
| The problem is it only recognizes the first product name and number.
|
| How can I fix this? What should I do different?
|
|
|