Cross referencing cells

[Hurler]

Should I use the 'IF' or 'LOOKUP' functions to fill a cell based on the content of another?
If C2 contains 'Cork' I need D2 to read 'Munster'. Indeed I will need D2 to read 'Munster' for a number of different C2 values.

 

[shyy]

Welcome to the Board!!

in D2 type in the formula bar =IF(C2="Cork","Munster","NotMunster")

 

[Jonmo1]

Welcome to the board..

Indeed I will need D2 to read 'Munster' for a number of different C2 values.

Put the 'number of diferent C2 values' in a range, say E2:E10

Then try
=IF(ISNUMBER(MATCH(C2,$E$2:$E$10,0)),"Munster","")

 

[Hurler]

Welcome to the board..



Put the 'number of diferent C2 values' in a range, say E2:E10

Then try
=IF(ISNUMBER(MATCH(C2,$E$2:$E$10,0)),"Munster","")


Thank you Janmo1. That worked and I managed to combine my different requirements into a single formula. Thanks for the help.

 

[Jonmo1]

You're welcome.