Need help with index match functions…inside.. (EXCEL 97)

Topic

New Reply

Hello..

I’m using this formula :

=INDEX(‘Database’!$B$14:$AO$83,MATCH($H$14,’Database’!$B$14:$B$83,0),29)

the problem is when there is no data in return on the specific cells,
it will shows #N/A. How can I hide this #N/A from show in my file
and also will be hide when I print the data..Many thanks

Reply | Quote

Replies

Lazy Way:

=IF(ISERROR(INDEX(‘Database’!$B$14:$AO$83,MATCH($H$14,’Database’!$B$14:$B$83,0),29),,INDEX(‘Database’!$B$14:$AO$83,MATCH($H$14,’Database’!$B$14:$B$83,0),29))

Reply | Quote

Thanks John..

Reply | Quote