vLookup working on all except 1 row.

[Pat_The_Bat]

I made a simple vLookup

The cell is D30 and F30

(Once I build it there, then I would extend to entire row F)

Data validation is tied to AY1:AY6

the vLookup works for all values except USDA. When I choose USDA in D30, I get a blank space in F30.

any help is appreciated.

 

[etaf]

any chance there is a space at the beginning or end of the text
check D30 and also the table entry

=D30 = AZ4 - if it is in row 4 , ot sure from image