Identify tariff based on number of pieces

[forfiett]

Hi Dears,

i have a excel file where for each value in column A have o identify correct tariff based on tariff strucure in columns fm E to G.
So for example if are 10 PCS, corresponding tariff is 9,5 €, ecc.

have attached also a file.
Book2.xlsx

Thanks
forfiett

[Kaper]

B2:

Please Login or Register  to view this content.

and copy this cell down

[Pete_UK]

You can use this formula in B2:

=VLOOKUP(A2,$E$2:$G$20,3)

then copy down.

Note that you might have to change the commas ( , ) to semicolons ( ; ), depending on your regional settings.

Hope this helps.

Pete

[Kaper]

Hi,

There could be also need for change of function name
If it's Italian version of Excel it could be CERCA.VERT instead of VLOOKUP

That's why I added the attachment - once opened in excel, it will use local function names and local separators :-)

[forfiett]

working, thankss!