if(and.. formula

		Microsoft Office Forums > Microsoft Excel > Excel
if(and.. formula

05-19-2016, 04:44 AM

paxon

Windows XP if(and.. formula

Office 2007

Novice

Join Date: Feb 2016

Posts: 13

Quote:

Originally Posted by Pecoflyer

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula Help	odonnest	Excel Programming	8	01-23-2015 07:18 AM
WHEN formula	agent007	Excel	5	02-06-2014 09:20 PM
Formula Help	clo312	Excel	11	01-11-2014 02:54 AM
What formula should I use?	TotalONE	Excel	3	11-26-2013 01:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:37 PM.