Wednesday, February 4, 2015

yogi_Making Match Formula Using Greek Letter For 'OMEGA' Work In Google Spreadsheet

             Google Spreadsheet   Post  #1888
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-02-2015
post by  Josh Stoler:
https://productforums.google.com/forum/#!mydiscussions/docs/oqS_PL4fTt8
My formula is not working with Omega, but works in Excel
As you can see in the attachment, the Index formula using Omega works and returns the exact answer I'm looking for.  However when you use this formula in Sheets and adjust for the correct row, it returns #ERROR!

Thoughts?

Josh
Attachments (1)
Test Gaps.xlsx
9 KB   View   Download