Google Spreadsheet Indirect in a VLookup [closed]

Google Spreadsheet Indirect in a VLookup [closed] I'm trying to convert an Excel spreadsheet into Google, but can't get this VLookup(Indirect)) combination to work.
Asked by: Guest \| Views: 246

Total answers/comments: 1

Comments display order:

Guest [Entry]

"Thanks to an answer on the Google support forum, I found the solution:

Thank you, A.P.L.

In GSheets, INDIRECT doesn't support ""open-ended"" ranges; you will need to specify row numbers:

=VLOOKUP(""Amount"",INDIRECT(CONCATENATE(A2,""!$A1:$B99"")), 2, False)

Simple :)"