HELPPPP

[Sasha_Small]

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?

[#2]

@Sasha_Small 

This looks like a homework assignment, so you should try to solve it yourself.

Apart from that: is that really the complete text of this assignment?

[#3]

if you are not here to help why respond though?

[#4]

@Sasha_Small I might be willing to provide a hint, but to be honest the question as asked makes little sense to me:

"using lookup, lookup the value in column 10"

Look up what? That's why I asked whether the question was complete.

[#5]

@Hans Vogelaar  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”.

[#6]

@Sasha_Small 

Thanks. I'm afraid it's still not clear to me what you want to look up in column 11.

[#7]

are you seeing the picture?

[#8]

thats the excel sheet we are working with and thats a question

[#9]

@Sasha_Small 

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?

[#10]

i do know how to do it using the IF FUNCTION. But I need the VLOOKUP function.

[#11]

@Sasha_Small 

Apparently I don't understand the question, sorry.