With the formula below, how/where do I add the IF ISNA function so that when it doesn't find the data it is looking for I don't get the dreaded #N/A? I have a good idea on how it should function, but I kep getting circular reference errors.
![]()
=INDEX('SHEET 2!C:C,MATCH(C8,'SHEET 2!$G:$G,0))
Bookmarks