“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

insert an if function that first tests whether the value in cell b16 is equal to an empty text string. if it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range f5:h8 using the value of cell b16 as the lookup value

Solved by T. B. in 20 mins

I need a formula to do a lookup from one text list and deliver a text result

Solved by O. J. in 17 mins

In cell B17, calculate the number of delivery days for the order. Insert an IF function that first tests whether the value in cell B16 is equal to an empty text string (""). If it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range F5:H8 using the value of cell B16 as the lookup value.

Solved by K. B. in 15 mins

I need a lookup formula that returns a value if the cell CONTAINS a certain text

Solved by I. H. in 23 mins

Need help with a v-lookup formula in Excel.

Solved by K. U. in 11 mins