Thread: Exact Match in Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Allen Mark Allen is offline
external usenet poster
  
Posts: 54
Default Exact Match in Vlookup
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
Reply With QuoteReply With Quote