linking cells from different page to automatically populate from a drop down box

[ladylulu]

hi guys I need your help please?
I have a spread sheet id like to set up to automatically populate a customer mark up percentage.
my data is on two pages. one page has the supplier details with mark up, haulage percentage fees. on the other I have a drop down menu in supplier column and next to it is the mark up % and haulage %
I would like to be able to select the supplier from drop down box on one page and it automatically populate the two % columns from the information on the other page. is there a way I could do this. I'm wrecking my brain trying to figure it outexcel1.png
excel issue 2.png

my data is in those images thanks in advance

[ChemistB]

Do you know how to make the dropdown menu (using data validation)? From there, you'd use a VLOOKUP. For example, if your dropdown menu is in A2 to pick a supplier.

In B2 (Markup) = VLOOKUP(A2, sheet1!$A$10:$G$30,3, FALSE)

Does that help? For more specific info, attach a spreadsheet (Go Advanced>Manage attachments)

[ladylulu]

I am having trouble figuring out the right formula can you please help

[JohnTopley]

Try

J5

=IFERROR(VLOOKUP([@SUPPLIER],'SUPPLIERS '!$B$5:$D$100,2,0)*0.01,0)

in K5

=IFERROR(VLOOKUP([@SUPPLIER],'SUPPLIERS '!$B$5:$D$100,3,0)*0.01,0)


It would be better if markup values were formatted as %

then formula would be

=IFERROR(VLOOKUP([@SUPPLIER],'SUPPLIERS '!$B$5:$D$100,2,0),0)

In above default is 0 if no supplier match

[ladylulu]

that is perfect thank you so much I am not great at advanced formulas. I know this may sound silly but in my customer cost how can I get it to automatically calculate the percentage without having to change it each time
so I need columns j k and m to give me customer cost. but I have to keep changing the percentage manually in my formula.

[JohnTopley]

in M7

=I7*(1+[@[MARK UP %]])*(1+[@[DELIVERY %]])

[ladylulu]

oh my god why didn't I try that I think I tried everything. you my friend are a star that is exactly it just what I need. thank you so much

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.