Help with IF formula

[Lewster]

As you will see from the attached doc i am trying to create and document that shows at a glance the time taken to clean from product to product.

On tab master times is the quick view, each clean permutation time is taken from a named tab i:e product 2 to 1 which I will populate a tab for each permutation.

On master descript times I will list all the items that could get cleaned and the times taken to clean, then I would like the product 2 to 1 tab to pick the time from master descript times tab for each item I list but not those I do not list. Hope you get my drift?

I have tried with the IF function but when I do not list all the items I have on the master descript times tab it returns 0 (false) on any that are after the missed item.

I have also hyperlinked the times to the relevant tab so more details can be seen if so desired.

Any help offered will be greatly appreciated.

Many thanks
Lewster

[Pete_UK]

Put this formula in B2 of the Product 2 to 1 sheet:

=IFERROR(VLOOKUP(A2,'Master descrpt times'!$A$2:$B$18,2,0),"")

then copy down to B17.

Hope this helps.

Pete

[Lewster]

That seems to work beautifully.

Thank you