IF/VLOOKUP help

**Shandy720** · 02-01-2009, 08:04 PM

Hi, I'm looking for some help perhaps using the VLOOKUP function but I am not sure if another function would be more helpful.

To briefly explain I am trying to set up a spreadsheet which automatically calculates the start and end dates of project tasks, by looking at the order in which tasks need to be completed.

I have attached a spreadsheet to show what I am trying to do.

Thanks for you help,

Andrew

**NBVC** · 02-01-2009, 08:13 PM

Will this in E8, copied down accomplish the task?

=LOOKUP(C8,$A$7:$F$21)

**Shandy720** · 02-01-2009, 09:37 PM

Thanks NBVC your formula works perfectly!

I was sure there would be a way but was stuck trying to use VLOOKUP.

so thanks for you help.

Andrew

**NBVC** · 02-01-2009, 09:41 PM

You could have also used Vlookup()

=VLOOKUP(C8,$A$7:$F$21,6,TRUE)

but Lookup() works just as well and you don't need to define the column number, you just need to know the first and last column and you need to be sure the first column is in ascending order....

Also,

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save