Thanks Xor I went about it a different way but am not quite there - it didn't help that my example didn't have the correct\matching columns for the 2 data extracts so I apologise about that.
I think I can get away with an INDEX & MATCH which as on my new attached example is working for the data which is manually entered into Data2 but doesn't work for the data which is a link to an SQL table\stored procedure.
Thanks
|