Hi Guys and Gals...new to the forum and I have excel question:
Here is my formula: =INDEX(Demand!$A$4:$Y$121,MATCH('GMT 900'!$C7,Demand!$A$4:$A$120,0),MATCH('GMT 900'!BL5,Demand!$A$4:$Y$4,0))
How can I use a nested statement to hide zeros and NA#'s which may result? I'm getting NA#'s because some of the numbers being searched for in the first match function do not exist. The data on the sheet being indexed changes from day to day.
Thanks in advance for your help!![]()
Bookmarks