J
JCC
I have the following mind bender:
Column D - Job Numbers
Column E - Lookup Job Name from "JobNames" (a named
range) by based on Column D Job Number.
Want I'm Seeking - For Column E to lookup the Job Number
in JobNames (the named range) and if found, return the
name. Simple Vlookup. But I also want E to be blank if
it doesn't find anything in D to begin with. Again,
simple, I wrote E to look like this. =if(d4="","",vlookup
(d4,jobnames,2) AND if the Column D contains a number (by
mistake) that is not part of the JobNames range, i want
it to return some kind of error message. This happens
because even though Column D is a validated list, it is
possible to copy (by dragging down) a cell above it.
Since our job numbers are not always sequential, that
autofill function is putting invalid numbers in the Job
Number column (D) and columng E is reporting a job name
that is the next one on the list. THus the need for an
error message to point this out.
Hope that wasn't too confusing.
Any takers???
JCC
Column D - Job Numbers
Column E - Lookup Job Name from "JobNames" (a named
range) by based on Column D Job Number.
Want I'm Seeking - For Column E to lookup the Job Number
in JobNames (the named range) and if found, return the
name. Simple Vlookup. But I also want E to be blank if
it doesn't find anything in D to begin with. Again,
simple, I wrote E to look like this. =if(d4="","",vlookup
(d4,jobnames,2) AND if the Column D contains a number (by
mistake) that is not part of the JobNames range, i want
it to return some kind of error message. This happens
because even though Column D is a validated list, it is
possible to copy (by dragging down) a cell above it.
Since our job numbers are not always sequential, that
autofill function is putting invalid numbers in the Job
Number column (D) and columng E is reporting a job name
that is the next one on the list. THus the need for an
error message to point this out.
Hope that wasn't too confusing.
Any takers???
JCC