| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup - Not Exact Match | Excel Worksheet Functions | |||
| Using Exact() with VLookup or Match | Excel Worksheet Functions | |||
| Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
| vlookup more than one exact match | Excel Worksheet Functions | |||
| using vlookup to find exact match | Excel Discussion (Misc queries) | |||
Linear Mode
