Nested If Statement Help

[jmujjf]

Hello All,

I've received some amazing assistance with a few complicated (to me) Excel issues on this site so I figured I'd try on this latest problem. I've received some criteria that I need to use to write some fairly complex IF statements in order to populate fields in Excel. I've provided a few samples of the criteria I was given below:

If AREA Like "GF*" And ( Index = "001" Or Index = "019") Then
Site = "CL"

If AREA Like "GF*" And ( Index = "002" Or Index = "029") Then
Site = "CL"

If AREA Like "GF*" And ( Index = "003" Or Index = "039") Then
Site = "CL Other"


There are like 30+ more criteria just like this and I'm wondering the best way to handle this in Excel. I've never had to figure out a formula that was this long and/or complex.

Thanks for any assistance you can provide.

 

[Kenneth Hobson]

Maybe =Match would suffice?

The formula for the Site value with Area = A1 and Index=B1 then the first =If:.
=IF(AND(MATCH("GF*",A1,0)=1,OR(B1=1,B1=9)),"CL",FALSE)

Just add the next If where False is at...