| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - return exact phrase
Try this:
=IF(COUNTIF('32pl'!B:B,I5),"Auto","Manual") -- Biff Microsoft Excel MVP "duketter" wrote in message ... Excel 2007 - I am trying to create a vlookup formula that returns an exact phrase if there is or is not a match. So far I have this: =IFERROR(VLOOKUP(I5,'32pl'!B:B,1,FALSE),"Manual") If there is not a match, it correctly returns "Manual" in my cell. However, if there is a match, I want it to return the word "Auto" in my cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a function to return EXACT row number of a match | Excel Worksheet Functions | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
| Extracting an exact phrase from a Cell | Excel Discussion (Misc queries) | |||
Threaded Mode
