I'm trying to compare a value in a cell to see if it is a match to a
list. Since the list is a single column, I was not certain how to do
this and attempted via the VLookup option and put my list into Column
A and in Column B...so if there is a better way, I should probably use
that.

Since I know if no other way, I used VLookup with mixed results. My
formula is as follows:

=IF(D2="","",(IF(D2<VLOOKUP(D2,Lookup!A:B,2),"",V LOOKUP(D2,Lookup!A:B,
2))))

Here is my problem with results, and it does not make sense to me:

Where D2 = "", I receive blank (OK)
Where D2 = "Cost Group", there is no match and I receive blank (OK)
Where D2 = "Administrative", it returns "Administrative" because it is
found in Lookup Table (OK)
Where D2 = "283111 - Achievement & Development", there is no match but
it returns #N/A (Not OK)

Why for "Cost Group" does it return blank but not for "283111 -
Achievement & Development" ?? Neither values are in the lookup
table. I'm trying to avoid #N/A being returned.

Thanks!!!