"steven.holloway" wrote:
Thanks Max, this works, ..

No prob. Glad it worked.

but I have a 2 further questions;
1. Are there any issues with using these "array-entered" formulas? - For
example, I have used this type of formula in the past and once I copied to
a
large area, the performance of the spreadsheet fade dramatically - and
made
the file pretty much unusable.

Yes, that's a trade-off. I'd manage it by setting calc to manual mode, go
about updating here and there w/o any fuss, then pressing F9 to calc only
when I'm done with the updates, or whenever required.

And as a non-array alternative, you could also use a helper col to concat
the 2 cols A and B in Sheet2, then just do a normal INDEX/MATCH on similarly
concatenated lookup values in Sheet1.

2. Can you add non "array-entered" formulas to an "array-entered"
formula? -
For example if I want to adapt the below formula to start with an
"if(iserror(" statement?

Yes, of course. But you would need to array-enter the combined formula.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---