Thread: [Solved] if(and.. formula
View Single Post
 
Old 05-19-2016, 07:56 AM
candybg candybg is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: May 2016
Posts: 9
candybg is on a distinguished road
Default
Oops - the formula as written by Pecoflyer should be:
=LOOKUP($G8,$B$21:$B$29,$D$21:$D$29)
(looking at Col B, rather than Col C)
If you paste that formula in I8, and drag down, you will get the results you expect.
Reply With Quote