View Single Post
 
Old 04-12-2018, 07:01 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2010 32bit
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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
File Type: xlsx MSOfficeForums38704.xlsx (9.8 KB, 9 views)
Reply With Quote