Get instant live expert help on lookup text in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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