Vlookup
 

Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

1245 betty
1249 joey


when I enter 1265 it should show nothing or "Not In Table"


Thanks in advance
ED

Vlookup
 

Generally,

=IF(ISNA(vlookup_formula),"Not present",vlookup_formula)

Your vlookup_formula should have FALSE or 0 as the 4th argument so
that you are looking for an exact match.

Hope this helps.

Pete


On Apr 6, 1:42 am, "Ed Davis" wrote:
Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

1245 betty
1249 joey

when I enter 1265 it should show nothing or "Not In Table"

Thanks in advance
ED

Vlookup
 

=if(isna(match(a1,sheet2!a:a,0)),"not in table",vlookup(a1,sheet2!a:b,2,false))

Ed Davis wrote:

Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

1245 betty
1249 joey

when I enter 1265 it should show nothing or "Not In Table"

Thanks in advance
ED

--

Dave Peterson

Vlookup
 

Thank you Dave
That worked great.


"Dave Peterson" wrote in message
...
=if(isna(match(a1,sheet2!a:a,0)),"not in
table",vlookup(a1,sheet2!a:b,2,false))

Ed Davis wrote:

Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

1245 betty
1249 joey

when I enter 1265 it should show nothing or "Not In Table"

Thanks in advance
ED

--

Dave Peterson

Vlookup
 

Hi Ed,

try this:

=IF($A7=0,"",IF(ISNA(VLOOKUP($B7,$K$6:$Q$199,3,0)) ,"not
present",VLOOKUP($B7,$K$6:$Q$199,3,0)))

All one formula - beware of line wraps.

Hope this helps.

Pete


On Apr 6, 2:10 am, "Ed Davis" wrote:

Hi Pete
My formula looks like this.

=IF($A7<0,VLOOKUP($B7,$K$6:$Q$199,3),"")

When I try what you suggested I get too many arguments.

A1 I enter a qty and B7 is where I enter the number and K6:q199 is the
table.



On Apr 6, 1:55 am, "Pete_UK" wrote:
Generally,

=IF(ISNA(vlookup_formula),"Not present",vlookup_formula)

Your vlookup_formula should have FALSE or 0 as the 4th argument so
that you are looking for an exact match.

Hope this helps.

Pete

On Apr 6, 1:42 am, "Ed Davis" wrote:



Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

1245 betty
1249 joey

when I enter 1265 it should show nothing or "Not In Table"

Thanks in advance
ED- Hide quoted text -

- Show quoted text -