Home » Questions » Computers [ Ask a new question ]

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: 33
Total answers/comments: 1
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 :)"