Implementing ISNA formula into equation.

[JPSIMMON]

Not sure with Index and Match how to implement ISNA properly to make #N/A --> blank cells, until a value is assigned when I run my macro.

=INDEX('Raw M'!$1:$1048576,MATCH('Auburn Bay'!$A58,'Raw M'!$A:$A,0),MATCH('Auburn Bay'!G$110,'Raw M'!$1:$1,0))

[simarui]

not 100% sure the ask here - a sample workbook would be helpful... what macro?

sounds like iferror might hehlp you out though:

Please Login or Register  to view this content.

that way if you get an error it will instead display a blank cell.

[Tony Valko]

...until a value is assigned when I run my macro.

=INDEX('Raw M'!$1:$1048576,MATCH('Auburn Bay'!$A58,'Raw M'!$A:$A,0),MATCH('Auburn Bay'!G$110,'Raw M'!$1:$1,0))

That makes it sound like one or both of these cells might be empty:

'Auburn Bay'!$A58
'Auburn Bay'!G$110

You could use IFERROR as suggested in some of your other threads but here's a different way.

Use a test to make sure there are 2 entires in those cells.

Something like this:

=IF(COUNTA('Auburn Bay'!$A58,'Auburn Bay'!G$110)<2,"",INDEX('Raw M'!$1:$1048576,MATCH('Auburn Bay'!$A58,'Raw M'!$A:$A,0),MATCH('Auburn Bay'!G$110,'Raw M'!$1:$1,0)))