Thread
:
vlookup must return a value that is greater than
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
Posts: n/a
vlookup must return a value that is greater than
If you use MATCH( ) then you will get the (relative) position in the
range - you can add 1 onto this and feed this into an INDEX( ) function
to get what you want.
Hope this helps.
Pete
Reply With Quote