Matching and Cell Referencing

Hi all

I'm trying to grab data from two sheets by first doing a match.
The match works, but how can I now reference ws2 so that I can pick up data if this match is true?

Any help much appreciated

Danny

Please Login or Register  to view this content.

Cheers Bob.

That will work for the time until I can revise the whole thing.

Thanks for your help!

D.