Matching and Cell Referencing

[l8sk8r]

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.

[Bob Phillips]

Use something like

Please Login or Register  to view this content.

[l8sk8r]

Cheers Bob.

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

Thanks for your help!

D.