USING RANDOM FUNCTION Values

Hi All I am creating a table with the following headings

Month
Prod Code
Item

I am using a random function to fill in the details
I want to fill in the item automatically in Item column based on the numbers generated in the prod.code column.

My prod code generates number between 1 and 20 only.
For example p002 in prod code the respective item column should show “Toyota”
For example p003 in prod code the respective item column should show “Honda”
For example p004 in prod code the respective item column should show “Volvo”

My code is below. Where & when should i assign the item values to the product code

Please Login or Register  to view this content.

Hi, grkchakri,

if you want to to hard-code the brand names you may work like this:

Please Login or Register  to view this content.

I´d suggest you work with a table and use WorksheetFnction.VLookUp to deliver the brand name.

Ciao,
Holger

you mean to say create a seprate product table with ids and names and use vlookup in my table . did i get that right

Hi, grkchakri,

exactly that - you would have less code and the ability to change within the sheet instead of changing code.

Ciao,
Holger