Combining offset, address, and match
I am having issues combining two formulas:
The output of the address/match formula is $AA$5. I would like to replace the $AA$5 in the offset formula with the address/match formula like so:
When I do this, excel says that the formula I typed contains an error. I have tried a number of different things with no luck. Any suggestions?
Thanks in advance
Re: formula issues combing offset, address, and match
OFFSET needs a cell reference but the address formula returns a text string, so your formula doesn't work. One way round that would be to convert the ADDRESS function to a reference by using INDIRECT.......but it's much easier to avoid ADDRESS in the first place, try just
Note: if the cell you are looking for in row 5 will contain exactly "Employee: " then you probably should use MATCH with a final argument of 0, i.e.
Last edited by daddylonglegs; 04-26-2010 at 06:43 PM.
Re: Combining offset, address, and match
That worked perfect. Thanks daddylonglegs
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1