Thread
:
Multi value Formulas
View Single Post
04-12-2018, 07:01 AM
p45cal
Windows 10
Office 2010 32bit
Expert
Join Date: Apr 2014
Posts: 956
In the attached, a lookup table in E2:F5, formulae in column B showing facto:
=INDEX($F$2:$F$5,MATCH(A2,$E$2:$E$5,1))
Attached Files
MSOfficeForums38704.xlsx
(9.8 KB, 9 views)
p45cal
View Public Profile
Find all posts by p45cal