vlookup question

I'd sure appreciate any advice and assistance with the following problem; I have a lookup tab which contains three columns: Column A is a tax ID #, Column B is a set of numbers and Column C is a list of street names. I need help with creating a lookup type formula for my column AB in the (worksheet/tab) titled 2009, which will look at and compare the data in columns F & G and compare them to columns B & C in my "lookup" tab and if a similar address is found based on both the street name and number then the tax ID # affiliated with that address from the "lookup tab" will be automatically placed in the column AB in the 2009 tab. I hope this makes sense. Any help would be greatly appreciated! I'm attaching a sample of my spreadsheet which is an excel 2007 type file.

Try this in AB6:

Please Login or Register  to view this content.

which, after you change ranges to suit, must be confirmed with CTRL+SHIFT+ENtER not just ENTER you will see { }brackets appear, then copy down.

To avoid #N/A errrors when no matches found, use:

Please Login or Register  to view this content.

Did you confirm the formulas with CTRL+SHIFT+ENTER keys all pressed at once? And then copy down.