2 different formulas depending on a cell value

[Reecenorman1996]

the below is the formula that iv tried to make work if cell f1 is SA i need one formula if its OA i need another

=IF(F1="OA",IFERROR(INDEX('SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],MATCH(TRUE,INDEX('SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref]=[@[Prop Ref]],0),0)),1)),IF(F1="SA",IFERROR(INDEX('SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],MATCH(TRUE,INDEX('SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref]=[@[Prop Ref]],0),0)),1))

thank in advance

 

[Fluff]

In what way doesn't it work?

 

[Reecenorman1996]

In what way doesn't it work?

comes back as #value!

 

[Fluff]

Ok, how about

=IF(F1="OA",XLOOKUP([@[Prop Ref]],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],1),IF(F1="SA",XLOOKUP([@[Prop Ref]],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],1)))

 

[Reecenorman1996]

Ok, how about

=IF(F1="OA",XLOOKUP([@[Prop Ref]],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],1),IF(F1="SA",XLOOKUP([@[Prop Ref]],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref],'SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],1)))

thank works thank you

 

[Joe4]

In the future, when marking a post as the solution, please mark the original post that contains the solution, not your own post acknowledging that some other post is the solution.
I have updated this for you on this thread.

 

[Fluff]

You're welcome & thanks for the feedback.