Hello,
I have a number of tables and I want to use a formula to lookup a value from each table depending on what has been selected in another cell. for example, A1 has "2" in it and B1 has "4".
I want to lookup "2" (from A1) in range / table A which will return £50, then I want to lookup "4" (from B1) in range / table B which will return £100. I then want the formula to add these values together and give me £150.
Is that possible? I have tried a number of formulas using vlookup with no success. Basically =vlookup()+vlookup(). It seems you can't have multiple vlookups unless nested though.
There may end up being 10+ values to look up in their own range and added together.
The workaround I came up with is to do the lookups on another sheet and then use a simple =sum to add them together. I would be happy with this method but also interested if it can be done in a single formula.
thanks.
Edit: I am basically trying to build a configurator if anyone knows of a good template?
I have a number of tables and I want to use a formula to lookup a value from each table depending on what has been selected in another cell. for example, A1 has "2" in it and B1 has "4".
I want to lookup "2" (from A1) in range / table A which will return £50, then I want to lookup "4" (from B1) in range / table B which will return £100. I then want the formula to add these values together and give me £150.
Is that possible? I have tried a number of formulas using vlookup with no success. Basically =vlookup()+vlookup(). It seems you can't have multiple vlookups unless nested though.
There may end up being 10+ values to look up in their own range and added together.
The workaround I came up with is to do the lookups on another sheet and then use a simple =sum to add them together. I would be happy with this method but also interested if it can be done in a single formula.
thanks.
Edit: I am basically trying to build a configurator if anyone knows of a good template?
