“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

Check if a string from column A is present in B. Details with example in a sheet.

Solved by M. H. in 18 mins

Hi,
In excel I need to check if there is any common word or string between two cells

Solved by B. H. in 21 mins

If I do not enter a date in E18, F18 must remain empty. Now there is Check

Solved by D. D. in 18 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 A. H. in 23 mins