View Single Post
 
Old 12-01-2016, 04:28 PM
joeu2004 joeu2004 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

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.
Reply With Quote