Thread
:
vlookup and match first value greater than
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Max
external usenet poster
Posts: 9,221
vlookup and match first value greater than
Think the earlier can be simplified to just:
=INDEX($E$1:$G$1,MATCH(TRUE,INDEX(OFFSET($E$1:$G$1 ,MATCH(A7,$A$2:$A$3,0),)0,),0))
where A7 = input for the product, as before
--
Max
Singapore
---
Reply With Quote
Max
View Public Profile
Find all posts by Max
vlookup and match first value greater than