cool...
I am by no means an expert and just learnt something.

I don't consider myself an expert either! I knew you needed a vlookup to get data from other sheets/workbooks so i googled it to refresh my knowledge on how it worked. Glad i did as it looks useful and i've learnt something too!

Wow, thanks guys, I think Belac's covers it - I'll give that a go tonight!

No worries, if i haven't explained the formula well enough for your scenario let me know and i'll try to clarify it..