If and function with three conditions

[beginvbaanalyst]

Hi Everyone,

I'm trying to add an additional condition that doesn't seem to work and I can't figure out why. The new condition is looking at another column for the word "yes".
My current formula is following:

=IF(AND(COUNTIF(_AG22[Loan ID],[@[Loan ID]]),_AG22[Open Date1]<="8/01/2022"),"-",VLOOKUP([@[Loan ID]],'Jul22'!B:H,7,0))

_AG22 - Table
Loan ID - Column
Open Date1 - Column
Jul22 - Table
If true then add dash, if false then vlookup the loan id for my current table to seperate table to pull info.

My new formula that doesn't work is following:
=IF(AND(COUNTIF(_AG22[Loan ID],[@[Loan ID]]),_AG22[Open Date1]<="8/01/2022",_AG22[Internal Refi]="yes"),"-",VLOOKUP([@[Loan ID]],'Jul22'!B:H,7,0))
Excel accepts the formula but doesn't seem to work, can't figure out why.
Here is my table.
What do you think could be my issue?

Type

Loan ID

Name

Join

Open Date

Open Date1

Original Limit

Balance

Unadvanced

Risk Rate

Change V2

Updated Change

Internal Refi

Payoff

1

212

N/A

N/A

N/A

44784

$10,000​

$3,250

$0.00

-

New

New

yes

-

 

[Fluff]

On my work computer, when I am home later today I will submit with XL2BB.

Ok