Can lookup (or other) function do this?

[xyz123]

Hi

I have two seperate excel files and am trying to automatically pupulate a column in one of the files based on some criteria. will do my best to explain as simply and clearly as possible:

File 1:
Column A Column B Column C
Item Code No ordered Price

File 2:

This file has a table based on two things:

No ordered (e.g. 1/ 50/100)

Item Code (same as item code in File 1) Price of item based on quantity ordered


Is it possible to update column C in file 1 with a price based on the table in file 2. i.e. if a customer orders 100 qty of item 100, price is X. If customer orders 250 quantities price is Y?

I am not sure if the formating in above tables will keep when i post the question, so apologies if its not very clear.

 

[Robert Mika]

Hi

I am not sure if the formating in above tables will keep when i post the question, so apologies if its not very clear.

Use Internet Explorer.
Just put borders around your tables and then copy and paste from Excel to the browser