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.



many thanks

[Pete_UK]

This seems to be a duplicate post without the attachment - send a PM to one of the Moderators to ask them to close this thread - you can see which Moderators are currently on line on the home page.

Pete

[Micbrook]

help.xlsx

lets try again. i couldnt attatch the spreadsheet, of course it will make more sense when people can see it

[Pete_UK]

You should only have one thread going at a time - stop using this one. Did you see my response in your other thread? How can a colour plus a car equal a cost?

Pete

[Fotis1991]

Thanks Pete.

1 more(3 until now) duplicate..?

For last time...

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.