Search:

Seems to work fine for me. I opened a new worksheet. I set J7 to 200. I pasted my formula into K7.

If I put Coronado in E7, then K7 = 200. If I put Akron in E7, K7 =0.

Do you need E5 or E7?...

I think Lookup will only work with ranges or value sets, not single cells.

You could try an IF OR statement, but you'd have to put in each E7="city".

=IF(OR(E7="Coronado",E7="San Diego"),J7,0)