Formula for listing a cell's contents as long as two adjacent cells meet the criteria

[Saxon]

Hello
First time poster. the final formula (I hope) for a work project is really stumping me. I need it to display the contents of a cell on a different sheet as long as 2 adjacent cells match specific criteria, it is causing me alot of headache to work out

 

[bbott]

Welcome to the board.

Are you able to post an example of your data? Sheet names, cell ranges, criteria, etc...

 

[Saxon]

much of it is confidential however so far my formula looks like this
=IFERROR(INDEX(VLOOKUP($F2,Call_Totalizer!$A$8:$E$600,Call_totalizer!$K$8:$K$600='sales',13,FALSE),""))
i'm entirely self taught on this project when it comes to formulas so I appreciate i may be going down completely the wrong road

 

[bbott]

Maybe this will get you in the right direction:

=IF(AND(condition 1,condition2),sheet name!cell address,"")

 

[bbott]

much of it is confidential however so far my formula looks like this
=IFERROR(INDEX(VLOOKUP($F2,Call_Totalizer!$A$8:$E$600,Call_totalizer!$K$8:$K$600='sales',13,FALSE),""))
i'm entirely self taught on this project when it comes to formulas so I appreciate i may be going down completely the wrong road

Does this formula work? Do you just need it to give the results based on your adjecent cell criteria?

 

[Saxon]

To break down what I think it should be doing
=IFERROR(INDEX:- this bit I know
(VLOOKUP($F2,Call_Totalizer!$A$8:$E$600:- if cell F2 matches cells in column A2 to A600 of the sheet Call_Totalizer
Call_totalizer!$K$8:$K$600='sales' :- and also Cells K8 to K600
,13,:- then display the contents of the adjacent cell in column 13 on Call_ Totalizer
FALSE),"")):- This bit I also know

 

[bbott]

A few questions:

(VLOOKUP($F2,Call_Totalizer!$A$8:$E$600:- if cell F2 matches cells in column A2 to A600 of the sheet Call_Totalizer
Call_totalizer!$K$8:$K$600='sales' :- and also Cells K8 to K600

Do they need to match in the same row (i.e. the value is in A100 and K100), or just appear somewhere in each range?

then display the contents of the adjacent cell in column 13 on Call_ Totalizer

Just to clarify, column M on the row that matches from column K?

 

[Saxon]

yes they need to match in the same row and column M is what I want to display as long as Column K says 'sales'

 

[bbott]

Does this work for you?

=IFERROR(IF(INDEX(Call_Totalizer!$A$8:$K$600,MATCH($F2,Call_Totalizer!$A$8:$A$600,0),11)="SALES",INDEX(Call_Totalizer!$A$8:$M$600,MATCH($F2,Call_Totalizer!$A$8:$A$600,0),13),""),"")

 

[Saxon]

still getting the error i'm afraid