Thread: Lookup Duration

Hi all, I am new to the forum and I am having a problem figuring out what formula to use. I have attached a mock version of the spreadsheet for reference (Excel 2003). As you can see from the mock file column L is project duration. Right now I have a listing of over 400 projects that I have to manually go through to enter the project duration on. What I am looking for is to have column L have some formula that will do the following. If Column F has a value between 1 and 25000 enter the # 3, if the value is between 25001 and 400000 enter the # 6, if the value is between 401000 and 800000 enter the # 9, if the value is greater than 800000 enter the # 12.

Any help would be greatly appreciated!

Thanks!
~Tracey

Tracey - welcome to the Board.

If you could re-title your thread to say: "Lookup Duration" then we can help - until then I'm afraid your thread title falls foul of the Forum Rules and we will get told off for doing so.

To edit your title click Edit on first post -> Go Advanced and adjust.

(ps. the clue is also in the suggested name )

Thanks for adjusting the title.

Using your sample file and above requirements

L14:
=LOOKUP(N(F14),{-9.99E+307,1,25001,400001,800001},{0,3,6,9,12})

or

L14:
=3*MATCH(N(F14),{-9.99E+307,1,25001,400001,800001})-1)