Forum Discussion

Copper Contributor

Aug 27, 2018

Solved

Issue Writing IF Formula

Hi all, There is probably a simple solution but I am not very skilled at excel and would love your feedback. I have tried to search other posts to see if someone has had a similar question to try bu...

excel

Formulas and Functions

Damien_Rosario
Aug 29, 2018
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
postcodes.xlsx33 KB

Damien_Rosario

Silver Contributor

Aug 29, 2018

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

postcodes.xlsx33 KB

Cassie Jones

Copper Contributor

Aug 29, 2018

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

Damien_Rosario
Silver Contributor
Aug 29, 2018
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