Thread
:
I need help with a formula
View Single Post
12-01-2016, 04:28 PM
joeu2004
Windows 7 32bit
Office 2007
Advanced Beginner
Join Date: Aug 2016
Posts: 32
In column D:
=IFERROR(VLOOKUP(C1,$A$1:$B$6,2,0),"-")
However, you cannot duplicate the format (black 2 v. red 4) unless you hand-code the Conditional Format.
joeu2004
View Public Profile
Find all posts by joeu2004