The IF-THEN-ELSE statement evaluates the conditions in the order listed. It will execute the corresponding code when a condition is found to be true. If no condition is met, then the Else portion of the IF-THEN-ELSE statement will be executed.If column A equals column B then return value in column C. Ask question asked 4 years, 4 months ago.. the core logic I need is if column A equals column B then return the value in column C. excel. share. browse other questions tagged excel or ask your own question.Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.This is the same as having IF B>0 THEN IF B>1000 THEN 1000 ELSE B, you just have to break it out into multiple columns. You could even have an IF/THEN D ELSE E in column C, then have different IF/THEN/ELSE formulas in D and E. those might even refer to other columns with IF/THEN/ELSE formulas.I have used LOOKUP quite a lot. The sheets all use a singular set of building price data, and due to various repair works, which are predicted to happen in various years, I have to scan the same set of data for each of the 50 building components to find the cost multiplier for that particular year.This Excel tutorial explains how to nest the Excel IF function with syntax and examples. It is possible to nest multiple IF functions within one Excel formula. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.excel formula training. formulas are the key to getting things done in Excel. In this accelerated training, you’ll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges.excel questions; Return Yes if text in cell is found in column on seperate sheet; Results 1 to 10 of 10. Return Yes if text in cell is found in column on seperate sheet. Ideally it would be possible for me to then copy down the formula to the cells below so that I can then apply the filter.