|
Re: Yet another Excel formula question for the experts!!
I guess you could have a separate vlookup table with the A values and the expected concatenation (or sum) of the other values.
eg, Vlookup sheet contains
one DogCatFish
two ElephantGiraffeBird
Then you formula would be something like
=If(concatenate(B1,C1,D1)=vlookup(A1,table),"True" ,"False")
HTH
|