I need an excel formula to lookup a column and return value-CodePudding

Home > OS > I need an excel formula to lookup a column and return value

I need an excel formula to lookup a column and return value

Time：10-26

I need cell C2 to lookup B2 for value 'SUSP' and return value as 'Suspended' in C2. If B2 is not value 'SUSP' then lookup A2 and return same value in C2

CodePudding user response：

Enter this into C2 and then drag the formula down to all relevant rows:

=IF(B2="SUSP","Suspended",A2)

Page link：https//www.codepudding.com/os/588146.html

Prev:How do I ask for a collection of n data points (x and y coordinates) until the java program reads a

Next:Why does the UI still freeze even though I use Task in C# WPF?

Tags：

excelif-statementexcel-formulaconditional-statementscell

Links：
CodePudding