Look up for a value left to the lookupvalue
Closed
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Mar 10, 2011 at 11:48 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2011 at 09:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2011 at 09:52 AM
Related:
- Look up for a value left to the lookupvalue
- A little to the left free download mac - Download - Puzzle
- Left 4 dead 2 download - Download - Shooters
- Google sheet right to left - Guide
- Left 4 dead download - Download - Shooters
- Cs 1.6 left hand command - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 11, 2011 at 05:24 AM
Mar 11, 2011 at 05:24 AM
you cannot use lookup in that case. you could either make use of a temp column to make it appear on right hand side or you can use a combination of MATCH and INDEX to find the value
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 11, 2011 at 07:35 AM
Mar 11, 2011 at 07:35 AM
the lookup funciton is working for this in excel.
but i am not able to get correct syntax in macros.
i also problem with another lookup function which is as
but it not working in macros.
but i am not able to get correct syntax in macros.
i also problem with another lookup function which is as
b = range("a4").value
worksheet.function.lookup(b,{25000,75000,150000;1,2,3})
but it not working in macros.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 11, 2011 at 09:52 AM
Mar 11, 2011 at 09:52 AM
is this correct ?
worksheet.function.lookup
i would think you need
worksheetfunction.lookup
again if you could add sample book with code and error, it would be easier and quicker to tell you what can be done
worksheet.function.lookup
i would think you need
worksheetfunction.lookup
again if you could add sample book with code and error, it would be easier and quicker to tell you what can be done
