Tuesday, February 26, 2013

yogi_LookUp Data In A Table (in Schedules sheet) And Compute Pricing In Another (Overview sheet)


                                          Google Spreadsheet   Post  #1047
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 26, 2013
user Peggy Albiz said:(http://productforums.google.com/forum/?zx=d9dujze9rels#!mydiscussions/docs/WFnC6HdJeMo)
Converting and Excel formula to work in Google
This formula works perfectly in Excel but when uploaded into Google Doc's it comes up with an error.  I did not create the spreadsheet but I am responsible for maintaining it.

How do I correct the uploaded Excel formula so that it can be used in the new Google Spreadsheet.

=HYPERLINK("@lookup(B9,UserVolumeDiscount,Schedules!B5:B12",USD_PerUser*(1-LOOKUP(D12,DiscountTable,DiscountRate))*D12)


Browser & Operating System (e.g. Firefox/Mac OSX): Windows 7  Chrome
Google Apps account 
Describe the steps you took that produced this error: Imported an excel spreadsheet.
Copy and paste any error messages:   #NAME? error
---------------------------------------------------------------------------------------------------

following is a solution to the problem