Link to home
Start Free TrialLog in
Avatar of Justincut
Justincut

asked on

Index Match Formula

Hi Guys, does anyone know how to put an ISNA around this Index Match formula?

=INDEX(Journals!P$5:P$1000,MATCH(TRUE,INDEX(Journals!B$5:B$1000=B7,0),0))
ASKER CERTIFIED SOLUTION
Avatar of andrew_man
andrew_man
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial