With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, May 1, 2012
yogi_LookUp Values Across Worksheets Where One Would Have Used LOOKUP Function In Excel
user CathB said: lookup values across different worksheets I'm trying to lookup values in one worksheet (named 'Location') from a list in a different worksheet of the same workbook. My formula in MS excel is
How do I get this to work in a google spreadsheet? I've attempted to mock this up in the attached spreadsheet.