VLOOKUP only working on part of my table?

[Rich_B]

Hi

I have the following formula:

=VLOOKUP(E2,'S:\RB_Folder\03_Spreadsheets\RE-QUOTES\[MASTER_DATABASE.xlsm]CLIENT_DATA'!$A:$G,2,0)

It has been working just fine for the first 132 rows of my ever-expanding table of data.

Suddenly now as I enter data into rows 133 or higher the formula will only return the value #N/A.

The formula continues to work fine for the data in rows 1-132.

If anybody could shed some light on this I would be extremely grateful.

Thank you

Excel 2007
Win 7
PC

 

[Sixthsense]

Your formula is perfect since it has been referred to whole column range.

Check what kind of data you are trying to match. If it is real number then matching it with text number will result #N/A error. So check both source data and the matching data TYPE to get rid of this issue.