Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
vlookup
Hi all,
vlookup, looks up a value and then place it somewhere else. I would like to know if there's a way to do the opposite. That is, if I find a value, don't display it, but if the value can't be found by vlookup, place some character in the cell to indicate it as such? Is there a way to do this? Thanks for sharing your thought. Ben -- |
#2
|
|||
|
|||
Hi,
=IF(ISERROR(VLOOKUP(A2,$D$2:$D$10,1,0)),"x","") Here, if A2 does not have a match in D2:D10, an 'x' is returned. Regards, B. R. Ramachandran "Ben" wrote: Hi all, vlookup, looks up a value and then place it somewhere else. I would like to know if there's a way to do the opposite. That is, if I find a value, don't display it, but if the value can't be found by vlookup, place some character in the cell to indicate it as such? Is there a way to do this? Thanks for sharing your thought. Ben -- |
#3
|
|||
|
|||
=IF(ISNA(MATCH(<your value,<your table, 0)),"###","")
On Wed, 5 Oct 2005 12:29:05 -0700, Ben wrote: Hi all, vlookup, looks up a value and then place it somewhere else. I would like to know if there's a way to do the opposite. That is, if I find a value, don't display it, but if the value can't be found by vlookup, place some character in the cell to indicate it as such? Is there a way to do this? Thanks for sharing your thought. Ben |
#4
|
|||
|
|||
Wow, what a great idea,
thanks B. R. and Myrna. Ben -- "Ben" wrote: Hi all, vlookup, looks up a value and then place it somewhere else. I would like to know if there's a way to do the opposite. That is, if I find a value, don't display it, but if the value can't be found by vlookup, place some character in the cell to indicate it as such? Is there a way to do this? Thanks for sharing your thought. Ben -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |