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..
