Mike that worked great but now how do I get it to return a blank cell instead
of #N/A ??

Regards

Mark

"Mike H" wrote:

Try this

=VLOOKUP(B4,'[GT Master Quote Tool.xls]Sheet1'!$A$2:$E$10000,2,FALSE)

Mike

"Mark Allen" wrote:

I am using this formula in a vlookup:

=VLOOKUP(B4,'[GT Master Quote Tool.xls]Sheet1'!$A$2:$E$10000,2)

Hoever I need an exact match, sometimes it returns the close match.

Any ideas.

Thanks in advance

Mark