Vlookup with an exact match

G

gigglygover

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exact VLookup 3
Exact Match in Vlookup 5
vlookup question - bring in all values? 6
VLookup 1
how do i use the text in a cell as a named range in a vlookup form 2
Vlookup with Multiple Rows to match with one row 1
vlookup in reverse 4
Exact match in vlookup 12

Top