Simple VLOOKUP takes the ID# and checks against Table1 (named range $B$2:$C$31) to get a name. But what I really need is whether or not there IS a name.
I figured out how to do this in two steps - by using VLOOKUP for the name,and then in the next column, testing whether it's "(blank)" - gets a 1 if it is not "(blank)"
However, when I use it against a set where the ID# doesn't exist in Table1, I still get a 1, even though it's not "(blank)" and it's not a name.
formulas in cells G5, H5, and I5:
Thanks in advance!
Bookmarks