Thread: Index Function
View Single Post
 
Old 05-02-2018, 07:38 AM
jennyyoung jennyyoung is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Apr 2018
Posts: 15
jennyyoung is on a distinguished road
Default Index Function

I am linking a range of one sheet to another.

I highlight the same size and shape of the data I want to link, and I click = then go back to the source data, highlight it, go back to the destination sheet, click CONTROL/SHIFT/ENTER.

It works but I get a lot of 0's.....How can I make it show blank cells instead of 0?


='\\177.177.1.14\Sales\Order Status 2018\[Jason''s Orders.xlsx]Jasons Customers'!$A$6:$M$94

thanks
Reply With Quote