you, my friend, are a genius...rock star of immense proportions! thank you
so very much!!!

"NBVC" wrote:


Are there many more combinations? If so, then probably best to create a
table on the side listing the A possibilities (e.g. in X1:X100) and the
B possibilities (e.g in Y1:Y100) along with the desired results (e.g in
Z1:Z100).

then apply formula

=Lookup(2,1/((X1:X100=A1)*(Y1:Y100=B1)),Z1:Z100)

this assumes table is in X1:Z100.. adjust as necessary.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943