Formula in two cells different result and not working for another item

Hi everyone,

This formula drives me crazy.

Goal: I would like to get the maximum of a column (hierarchy level (in column BG)) by having two criterias included.
1. specific name (in column BQ)
2. specific location (in column K)

I am using this formula:
=MAX(IF(Baseline!$BQ$7:$BQ$3303="name";if(Baseline!$K$7:$K$3303="Location";Baseline!$BG$7:$BG$3303)))

and alternatively this formula:
MAX(IF((Baseline!BQ7:BQ3303="name")*(Baseline!K7:K3303="Location");Baseline!BG7:BG3303))

In one cell it is working, in another cell not. Also it is working for one name, but not for another name. Do you see any mistakes in here? Or do you have an alternative formula which should be working?

Thank you so much for your help already in advance!

Best regards,
#läuftbeimir?!

In my sample it is not working at all :D

So open for suggestions....

Hi,

thank you very much for your respond!

Where would you put the equals? In the formula I found online it is exactly the way I do use it right now. Also there should be no comma, but semi-colons - like I did it.

May you be able to write the formula (as you think it should be) in here?

Best regards