Auto fill data from another sheet

[BelleH123]

Hello, Im trying to create a BOP sheet where i input product codes and their descriptions are auto filled from another sheet.
I cannot seam to do this with help!

I have a list in page two looks like this.
collumA= product code. Collumn B= product description.

Page 1 needs to auto populate the data from collum b depending on what code was selected from collumn A.

Any tips?

[TMS]

Try:

Please Login or Register  to view this content.

[BelleH123]

That ones says there is a problem with the Formula?
I tried it on a blank excel too just to double check.

[popipipo]

Change the comma in semicolon.
Maybe that will help.
If it does'nt upload a small excel file.

[BelleH123]

Ok here is a simple excel sheet that might help me explain myself!

Thanks so much guys.

[TMS]

Please help me with a formula. If I type 200ch in A1, I would like B1 to auto populate with 5.016. The part numbers and coades are specified on the second sheet.

Cell B1:

Please Login or Register  to view this content.

or, depending on Regional Settings:

Cell B1:

Please Login or Register  to view this content.

That is, change all the commas to semi-colons

[BelleH123]

test.JPG
Please see attached pic

[BelleH123]

Whoops! i had a ' instead of a " !!!!

Thanks heaps! its working perfectly.

[TMS]

You're welcome.

Usually easier to copy and paste rather than retype, especially for long or complex formulae



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.