Does any one know a statement for the following

if A1:a1000000= this information is a range between numbers

700-701

or

703-705

or

707-708

or

713-714

or

717then B1 = 3

might try a look up table

I have the formula in using LOOKUP but i cant seem to keep the tAble range from changing. i keep getting =LOOKUP(F1,'[Zip + Zones]Zip + Zones'!A2:A913,'[Zip + Zones]Zip + Zones'!B2:B913)

=LOOKUP(F2,'[Zip + Zones]Zip + Zones'!A3:A914,'[Zip + Zones]Zip + Zones'!B3:B914)

=LOOKUP(F3,'[Zip + Zones]Zip + Zones'!A4:A915,'[Zip + Zones]Zip + Zones'!B4:B915)I need the LOOKUP_Value to change

NOT the LOOKUP_VECTOR OR the RESULT_VECTORHow can i continue to paste without the those changing and only the value to change

Ask Your Question

Weekly Poll

Do you think Apple's new iPhone X series of phones are groundbreaking?

Discuss in The Lounge

Poll History