Forum Discussion
Re: Issue Writing IF Formula
Hi Damien,
Thats awesome, I am in QLD! Our other office is in Melbourne.
I believe so. I would like to have a column where I manually input the postcodes of each property and the column beside it will determine whether it is CAT 1, N/A.
I was doing some more research and I am not sure if maybe a MATCH formula would be better and to put all the possible postcodes into a table on a separate sheet.
I tried this but an error message also came up.
Please help! lol
:)
3 Replies
Hi Cassie
I've had a bit of a play. Try the worksheet I've attached where I have input all the Cat 1 Postcodes into a sheet called Category 1, and I have created a formula on another sheet.
The formula I have used will reference the Category 1 postcodes and produce your desired result:
=IF(COUNTIF('Category 1'!A:F,A2)>0, "Cat 1", IF(A2="", "", "N/A"))
Let me know how you go? Hopefully this helps with a workable solution for you.
Cheers
Damien
Legend!
Thank you so much, this worked perfectly!
Really appreciate it. I didnt think we would be able to do it and we would have to look at the guide each time.
Cassie
Happy to help Cassie! What will you do with all that free time now (haha)?
All the best with your Excel work and see you around the forums!
Cheers
Damien
