Excel 2007 : Find and match - Vlookip/Script

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