Return value base on two columns

		Microsoft Office Forums > Microsoft Excel > Excel
Return value base on two columns

FAQ

Thread Tools

Display Modes

02-13-2017, 12:00 AM

xor

Windows 10 Return value base on two columns

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

Select for example D1. Press Ctrl and 1 to bring up the Format Cells dialog. You should see that Custom (under Category) has been chosen and that the format type is ;;;
This format type ensures that irrespective of what is entered in D1 the cell will appear blank.
This is a custom format (which I maybe should have said instead of user defined format).

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel / Mail Merge - Return Column Headers for All and Any Columns with Values	eduams	Mail Merge	1	09-26-2016 07:02 PM
Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match	krispykreme	Excel Programming	1	09-09-2016 11:25 AM
Creating small data Base	quintinros	Excel	2	06-26-2014 12:28 AM
Vlookup two columns return 3rd	jennamae	Excel	11	01-12-2014 02:53 AM
Calendar Base	prayojana	Project	0	11-12-2007 01:13 AM

Other Forums: Access Forums

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