Vlookup with an exact match
 

Need to use Vlookup to bring data forward, but if there is no exact match
bring back nothing, not one that is the closest value.

my formula so far is =vlookup(a1,NamedRange,2)
looking up a1 from my named range and brining back value from colum 2 in the
named range.
But if A1 does not match anything in the named range then it should either
be blank or put a message perhaps No Match founc
did post this yesterday, but I cannot view the response.

Vlookup with an exact match
 

.. did post this yesterday, but I cannot view the response.

Click this link (you have 3 responses to your earlier post):
http://tinyurl.com/3wwhrq
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---