Excel 2007 : Find and match - Vlookip/Script

Hi,

I have attached a xls that i need a Vlookup/script creating for if possible?

I need sheet2 to look up sheet1 and find a match with the membership number and create a 3rd sheet with the found data. Though i need the dining data to copied over with it..

Hope this makes sense..

Thanks

Darren

Originally Posted by tigeravatar

Darren,

Most of the Membership numbers in sheet2 don't have a match in sheet1. In sheet2, cell D2, try this formula:
=IF(ISNUMBER(MATCH(A2,Sheet1!A:A,0)),VLOOKUP(A2,Sheet1!A:B,2,FALSE),"Not found")

And then copy down. Is that something you can work with?

Hi,

Yeah thats correct, only a few members have a extra package deal associated with them..

I'll check the lookup - thanks again :-)

Darren

Originally Posted by macpegg

Hi,

Yeah thats correct, only a few members have a extra package deal associated with them..

I'll check the lookup - thanks again :-)

Darren

Thanks again - Works nicely :-)

Darren