Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #813 Oct 17, 2012 www.energyefficientbuild.com.
user Jesse Stuart said: (http://productforums.google.com/forum/?zx=9jrp4o21m1am#!category-topic/docs/spreadsheets/TQ40gwo84K4)
Converting an Excel Formula
Hey guys, I was wondering if someone could help convert this Excel formula to use with Google Spreadsheets. It works in Excel but for some reason I can't get it to work on Google. Here is the code...
user Jesse Stuart said: (http://productforums.google.com/forum/?zx=9jrp4o21m1am#!category-topic/docs/spreadsheets/TQ40gwo84K4)
Converting an Excel Formula
Hey guys, I was wondering if someone could help convert this Excel formula to use with Google Spreadsheets. It works in Excel but for some reason I can't get it to work on Google. Here is the code...
=IFERROR(VLOOKUP("*test*",G3:H
Any advice?
-------------------------------------------------------------------------------------------
as of now (Oct-17-2012), Google spreadsheet does support use of wildcard with VLOOKUP function, so following is a WorkAround solution to the problem
No comments:
Post a Comment