I have two accounts (consecutive order)dumping into one line item on my P&L statement. When I use the following formula:
=" "&ADGETx("gldata.DESC",$xx)it appears to pull the account description that is associated with the first account number in the referring column.
How do I get it to pull the account description that is associated with the 2nd account number?
Thanks

If you are using =ADGETF(), then you pick up the first value in the range. Use =ADGET() to pick up the last value.

Thank you so much Andrew; as expected it worked:)!