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.
|