Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - return exact phrase
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - return exact phrase
Here is one solution...
Expand your VLookup to columns B and C. (B:C) In column C, put the word Auto in every cell (or, alternatively, you could put a different value for each row.) Then Hide column C. (you could use security to protect the column, if necessary.) Then, change the column index number in your VLookup from 1 to 2. When a match is found, you'll see the value in column C. When it's not found, you'll see your error message. "duketter" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - return exact phrase
=IF(ISERROR(VLOOKUP(I5,'32pl'!B:B,1,FALSE)),"Manua l","Auto")
If this post helps click Yes --------------- Jacob Skaria "duketter" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - return exact phrase
I don't have 2007, but believe this this should also work in 2007
try =IF(ISERROR(VLOOKUP(I5,'32pl'!B:B,1,FALSE)),"Manua l","Auto") this will return the text Auto if there is a match otherwise its will give you Manual -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "duketter" wrote: 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. |
#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. |
Reply |
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) |