Index Function

		Microsoft Office Forums > Microsoft Excel > Excel
Index Function

FAQ

Thread Tools

Display Modes

05-02-2018, 07:38 AM

jennyyoung jennyyoung is offline

Windows 7 32bit Index Function

Office 2010 32bit

Novice

Join Date: Apr 2018

Posts: 15

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLookup and Nested IFs or Index Function	SavGDK	Excel	10	04-08-2016 10:06 PM
Help with Index Function to Select Range of Cells	bretyuin	Excel	1	02-24-2016 05:11 AM
Index Match Function across different worksheets	shay_mt	Excel	2	04-27-2015 06:04 AM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 PM.