Forum Discussion
Unusual Excel Help Request, Perhaps
Hello, I'm sorry thing is lengthy, but I desperately need assistance with the following problem: I have a worksheet where Tab A is divided into two sections (say Peter and Stephen). Each contain a ...
Let's say you want to return the last value of column D om Tab A
=LOOKUP(9.99999999999E+307, 'Tab A'!D:D)
- Thank you for responding. To clarify, this would return the last total from column D regardless of it's row? And how do I combine it with the last total from column F on Tab A to a cell on Tab B?
> this would return the last total from column D regardless of it's row?
Yes, indeed.
The last total for column F would be
=LOOKUP(9.99999999999E+307, 'Tab A'!F:F)
If you want to add them together:
=LOOKUP(9.99999999999E+307, 'Tab A'!D:D)+LOOKUP(9.99999999999E+307, 'Tab A'!F:F)
- Hans,
Thank you for your help. I tried entering your formula (replacing Tab A with Tab June, and D:D with E:E) and pressed enter, but it opened a search box prompting me to open an existing Excel File in ThisPC>Documents. When I close that down it returns "#N/A" on the sheet with the formula instead of the total. Might I ask a minute more of your time to tell me what I'm doing wrong? Thanks very much.
