cell combinations

[Micbrook]

hi

i have a 'simple' spreadsheet where i would like to log every combination from the A + B column give an answer taken from the D column.

example.....

A1 + B5 = D1

the result of D1 (£1) would show in the blue answer box. there may be more than one combination that shares the same answer.

i assume this is possible but i dont know how to do it. any help appreciated.

\1

many thanks

[Pete_UK]

It's not a good idea to post a picture of a sheet - why not post the Excel workbook instead, and then contributors can play about with formulae directly in it. Also, some people are unwilling (or not allowed) to download files from a third party site. You can attach the file directly to one of your posts (the FAQ describes how to).

Having said that, I don't understand what you want - how can a colour (column A) plus a car (column B) equal a cost (column D)? I think you need to explain more clearly what you want to achieve, and the logic behind it.

Hope this helps.

Pete

[Micbrook]

wow didnt realise i duplicated 3 times sorry guys

ultimately it doesnt matter what the content is, its the coordinates that matter.

id like to preset it so it knows if i do A4 + B2 = D whatever i preset it to

[ArsenalCityGent]

help.xlsxAssuming you want someone to make a colour and car choice and based on the Car choice a value is returned, then is the attached what you are looking for, you need to be mindful of more information about your issue makes for a quicker more accurate answer.

[Micbrook]

thanks thats great. however, where would i find the sum so i can set the values?

[ArsenalCityGent]

SUM? You need to be more specific....I am picking values opposite the car name, but you could easily create a new pricing table and refer to it in the VLOOKUP statement in you blue answer box.

If you are looking for some kind of running total of all choices made in say one day (week, month etc) then this will need either macros/vba to store each selection.

[ArsenalCityGent]

help.xlsx.

I have also added a cost for colour if this helps you understand what is happening.

[Micbrook]

I'm sorry i don't get it

=IF(ISNA(VLOOKUP(B13;B1:D8;3;0));"";VLOOKUP(B13;B1:D8;3;0))

i don't see where you would put the answer in there so it knows what it is