mickimouse75
New member
Good day,
Thank you for any assistance you may be able to provide.
I normally use vlookup to retrieve information, and am wondering if its possible to retrieve data from a specific section of an excel sheet without having named ranges, etc.
For eg., I'm trying to use the following formula to retrieve the Account Balance of Account 16605 ($6,836.45) ...
=VLOOKUP("Account Balance*",Sheet1!$AI:$BK,22,FALSE)
Of course, I only get the first instance of "Account Balance*".
Is there a way to insert something into this formula to first find and goto "16605", and then run the vlookup?
File attachedView attachment GL_Detail_Listing.xlsm
Thank you,
Mike
Thank you for any assistance you may be able to provide.
I normally use vlookup to retrieve information, and am wondering if its possible to retrieve data from a specific section of an excel sheet without having named ranges, etc.
For eg., I'm trying to use the following formula to retrieve the Account Balance of Account 16605 ($6,836.45) ...
=VLOOKUP("Account Balance*",Sheet1!$AI:$BK,22,FALSE)
Of course, I only get the first instance of "Account Balance*".
Is there a way to insert something into this formula to first find and goto "16605", and then run the vlookup?
File attachedView attachment GL_Detail_Listing.xlsm
Thank you,
Mike