Excel-INDIRECT FUNCTION

Posted by Analyst in Excel, Excel-Functions, Excel-Indirect function

You are here: Home > Excel-Indirect function > Excel-INDIRECT FUNCTION

on Jun 5, 2009

This question was asked by a user ( His Exact Words):

I have two formulas in two cells that generate a cell address in each.How do I use the cell address value given in these cells to select a range (in a formula) and then find the highest number in that range? For Example my formulas return the following cell addresses:E1 & E2 need the formula to basically say =sum(E1,E2) but without the manual input - the range in the formula needs to come from the cells with the cell addresses.

Basicly what he wants is if he has a cell (say G3) which has a value say'E1' and another cell (say H3) which has a value 'E2' how can he sum E1 and E2 (note:these cells have 'E1' and 'E2' in them and not '=E1' or '=E2')This can be solved using the indirect function.

Solution:

Use the following '=SUM(INDIRECT(G3),INDIRECT(H3))'.
(Click on the images to Zoom)

This entry was posted on Jun 5, 2009 at 3:08 PM and is filed under Excel, Excel-Functions, Excel-Indirect function. You can follow any responses to this entry through the RSS 2.0. You can leave a response.