Getting information from 1 source to another

Topic

New Reply

Good afternoon

1 have a combo box that is linked to D9 and takes its value from column 2 in a range of 3 columns, for example

Part Number = column 1 (Begins A12)
Part Description = column 2 (Begins B12)
Part price = Column 3 (begins C12)

On a second worksheet I am constructing an order form and need to show the the part description, therefore

=Parts!D9 shows the partnumber
=Parts!combobox1 = #NAME£

Any ideas please how I can get the part number to show?

Reply | Quote

Replies

You’d have to do a lookup on a table that holds both the part numbers and the descriptions.

Reply | Quote

Thanks Jan Karel

This is not something I am familiar with, I have tried a few things based on some Googling and I think it should look something like this

=Vllookup(PARTS!D9,PARTSLIST,1,FALSE)

Where:-

PARTS! is the sheet that contains the range

D9 is the linked combo box cell (from a control toolbox combo)

PARTSLIST is the named range I have given the list which is B56:D140 and from where D9 on the PARTS worksheet gets it information

Column D56:D140 of the PARTS worksheet contains the names I want to display and as it is the 2nd column in the PARTSLIST named range I have assumed it would be referenced 0,1,2 so 1 is column D?

Can you give me a pointer on where I have gone wrong?

Thanks

Reply | Quote

1 is the first column, so the column you are already doing the match with the part number. You need 2 or higher.

Reply | Quote

1 is the first column, so the column you are already doing the match with the part number. You need 2 or higher.

Thanks Jan Karel

Last night I could have sworn that I tried 0,1,2,3 but none worked and then hey presto it did today

Thanks again

Reply | Quote