Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Get Excel Cell Values

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Back to Excel Model Builder Start

Get cell's value    
 
This tool is very useful to create cells in a snap. So, we don't need to build complex formulas; In other words, "Get cell's value" let us to build formulas that indirectly, reference to other cells with the possibility of to make variations to according to the row and/or to the column.

Let's see an example:
We want to compare the sales done in March to the ones done 2 months ago.

 
 
 
We will use the tool in the green zone.
We press the corresponding button and a window is displayed with the following fields:
 
Reference Cell = This is the cell from where we will search the value to extract.

Variation in rows = Number of cells downward or up, from the Reference cell.

Variation in columns = Number of cells leftward or rightward, from the Reference cell.

Left or top = put the variation to negative.

Right or down = put the variation to positive.

Default value = Empty or zero (if both are zero, the value found is in the Reference cell.

 
There are 3 ways to obtain the result.
First case: Doing directly reference to the cell from which we need the value.
Second Case: Taking as reference the cell where we want to paste the result.
Third Case: Taking as reference any cell.

 

View Demos

Excel Model Builder  Secure Payment Options

Pricing:
1 License $129.95 USD
2 - 5 Licenses $110.95 USD
6 - 10 Licenses $97.95 USD
11+ Licenses $64.95 USD

Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site. Send payment confirmation to [email protected] 31 days after purchase.

 

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us