Help with IF formulas

[MarkRadcliffe]

Hi

Can you help me with a formula that returns the word "Primary" or "Secondary" based on a list of names and a list of sectors.

Column A is the list of names, Column B is the list of Sectors and Column C is empty - for the Primary/Secondary data to be returned to.

I've attached an example, what I'm hoping to do is:

If Column A has "Mr A Test" and Column B is "Finance", return "Primary" in Column C.
If Column A has "Mr A Test" and Column B is "Passenger", return "Secondary" in column C

Hope you can help, thanks

[Glenn Kennedy]

What is the relevance of the name???


=IF(B2="Finance","Primary","Secondary")

copied down. if that's not right, please show some manually calculated results.

[MarkRadcliffe]

Hi Glenn,

It didn't work.

I have a list of names, each of them is allocated to a sector (the Primary) but sometimes they deal with a different sector (the Secondary)
I've updated the original sample so hopefully it will put a bit more context around it.

Mr A Test deals with Finance
Mr B Test deals with Passenger

Thanks
Mark

[Glenn Kennedy]

I knew it wasn't correct, as you hadn't supplied enough information!!

=INDEX($G$1:$H$1,SUMPRODUCT(($G$2:$H$3=B2)*($F$2:$F$3=A2)*(COLUMN($G$2:$H$3)-COLUMN($G$2)+1)))

see sheet for context.

[MarkRadcliffe]

Thanks so much for your help, that's perfect. In my head it made perfect sense

[Glenn Kennedy]

That's 'cos you know what you're doing and are familiar with the requirement... We're not....

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[AliGW]

Please come up with a more descriptive thread title next time you need help (see forum rule #1). Thanks.