Wednesday, July 24, 2013

yogi_Use QUERY Function With IMPORTRANGE To LookUp Values For Select Entries

                                          Google Spreadsheet   Post  #1304
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 24, 2013
user maggien (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/ISFb9rF6vVY)
Array formula with vlookup that is not a number
I have this vlookup that I need to convert into a arrayformula

=VLOOKUP(C2, 'inventory'!$A$2:$I$500, 5, false)

After reading posts I tried:
=ArrayFormula( VLOOKUP( C2:C ; 'inventory'!$A$1:$F$300 ; 5 * SIGN( C2:C ); FALSE ))

But it gives me an error "value not a number".

Any ideas how to work this?

Thank you!
------------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment