Multiple IF with Single Look Up and AND function

[sg2209]

hi Friends,

i am trying creating a formula where IF and AND functions matched then vlook up however not getting the desired results .

I want IF Cell A4="First",And (B4="Track 1", then look up value populate the scores unfortunately when i am running the formula

it says A4= First and B4 = Track 1 however against ROBIN i am not getting the scores for Robin.

Attached is the Dummy Data, Can you please review and help me

 

[6StringJazzer]

There is nothing attached. Here is the general idea.

=IF(AND(A4="First,B4="Track 1"),VLOOKUP(A1,B1:C99,2,FALSE),"false case")

 

[sg2209]

Thank you the response though i had tried this , not getting the expecting result, when i drag down the formula , its not throwing the results

 

[Michael M]

Where is the dummy data ??
AND
you may have to make the VLOOKUP table range absolute

=IF(AND(A4="First,B4="Track 1"),VLOOKUP(A1,$B$1:$C$99,2,FALSE),"false case")

 

[6StringJazzer]

Thank you the response though i had tried this , not getting the expecting result, when i drag down the formula , its not throwing the results

Did it work in the first cell? if so then see Michael M's post for the fix.

 

[sg2209]

Worked
Thank You so much everyone