Microsoft Office Forums - View Single Post - [Solved] if(and.. formula

Thread: [Solved] if(and.. formula

View Single Post

Old

05-19-2016, 04:44 AM

paxon

paxon is offline

paxon uses Windows XP

Windows XP paxon uses Office 2007

paxon uses Office 2007

Office 2007

Novice

The original poster

Join Date: Feb 2016

Posts: 13

paxon is on a distinguished road

Default

Quote:

Originally Posted by Pecoflyer

View Post

Perhaps =LOOKUP($G8,$C$21:$C$29,$D$21:$D$29)

Drag down as needed

Thank,

But I would be more interested in understanding how if(and... works to keep the range that I have between the numbers.

Reply With Quote