Forum Discussion
HELPPPP
11, using lookup, lookup the value in column 10, write “Gain” if the value in column 10 is greater than “one” otherwise “Loss”. what is the formula?
HansVogelaar In Column 11, using lookup, lookup the value in column 10, write “Gain” if the value in column 10 is greater than “one” otherwise “Loss”.
Thanks. I'm afraid it's still not clear to me what you want to look up in column 11.
- thats the excel sheet we are working with and thats a question
- are you seeing the picture?
Sorry, I hadn't noticed that you edited the first post.
The first row with data is row 3. The formula in K3 has to look at the value of J3.
If J3 is >1, return "Gain", otherwise return "Loss".
That is basically the recipe - you can use the IF function
Does that give you a start?
- i do know how to do it using the IF FUNCTION. But I need the VLOOKUP function.