Wednesday, October 17, 2012

yogi_WorkAround In Google Spreadsheet For Use Of Wildcard In Excel VLOOKUP Function

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #813  Oct 17, 2012

user Jesse Stuart said: (!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:H23,2,0),"Not present")

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