Vlookup multiple tables?

[ace2302]

Hello Wise ones

I am trying to create my own postage rate calculator, I have attached my test spreadsheet showing as far as I have got to date
At present I can put a weight in G3 and it gives me 3 different results in F3, G3 and H3
I am wanting the ability to choose one of these F3, G3 or H3 and have I3 show the total of that choice + D3 (with me so far??)
I have looked through loads of threads and have only succeeded in baffling myself
As I am a novice to this sort of thing any help would be gratefully appreciated

Many thanks
Peter


test2807.xlsx

[Palmetto]

I am wanting the ability to choose one of these F3, G3 or H3 and have I3 show the total of that choice + D3 (with me so far??)

What is the criteria for choosing which of the three cells to return?

Are you looking to factor in the least number to get the lowest postage?
Tell us the logic of choosing which value and certainly a solution will be given.

[ace2302]

Hello Palmetto,

I would like to be able to see the different total in I3 dependant on the postal rate (f3,g3 or h3) I choose, as it is now I have to manually change the formula in I3
Or should I just have ALL the different totals showing in their own columns ???

Peter

[Palmetto]

Insert a column between H & I and give it a header of "Pick Rate"
In the cell below this header use Data Validation with the list option.

The list items could be: 1st Recorded, 2nd Recorded, 2nd Standard

Replace the existing addition formula (D3+F3) with this:

=IF(I3="2nd Recorded",G3+D3,IF(I3="2nd Standard",H3+D3,F3+D3))

See attached.