If one cell contains X make other cell contain Y

[fuzzyfuzzy]

Hi,

Been struggling with this for a few days and given up. Hopefully you guys will help.

Basically, I want a column to recognise if another cell in the same row contains x then it will display Y

For instance, if B contains one of the cities, I want E to auto-populate the number for each


A B C D E
1 London 10
2 Manchester 12
3 Birmingham 6
4 Newcastle 11
5 Leeds 2
6 Sheffield 9
7 Norwich 6
8 Cardiff 5


I've tried all sorts and going round in circles, i'm sure it's fairly straight forward for those in the know but i'm totally lost with it now. Any help, very much appreciated.

Cheers

 

[Aladin Akyurek]

One of:

=IFNA(LOOKUP(9.99999999999999E+307,SEARCH($H$24:$H$34,$A2),$J$24:$J$34),"")

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH($H$24:$H$34,$A2),$J$24:$J$34),"")