Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Formula
I am trying to create a formula that will read a name and if that name
matches in another column, then it would return a value in a represented cell. Column A B C D E F G Row 1 6 5 4 3 ROW 2 Jags Eag Boy Bucs Tom Row 3 Jerry Row 4 Eag Row 5 Fred I need the one formulae to say if A2s values is represented anywhere in column G, then return the value of 6. So for instance, B2, has a name Eag, that value is one of the values in column G. I would need the formula to return the value of 5. Any help????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |