Previous Topic Next Topic

Lookup error in code

Closed
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 11, 2011 at 04:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2011 at 05:35 AM
Hello,

Hi i am using this code for lookup 

dim b , n as long
b = Cells(2,1 ).Value
n =LOOKUP(b,{25000,50000,100000;1,2,3})


it doesnot give me result, what is the right syntax for lookup.

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2011 at 05:35 AM
there are two ways to use lookup

LOOKUP(lookup_value,lookup_vector,result_vector)

and

LOOKUP(lookup_value,array)
0

Similar discussions

Unlock code
Priya -
HelpiOS -

1 response
Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

2 responses
error code 230000
Rajvir -
dwebb -

1 response
How to unlock Gameloft games
Kefas -
HelpiOS -

3 responses
lava hard reset & factory reset
AVAY -
Har -

3 responses