# HELPPPP

Occasional Contributor

# 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?

10 Replies

# Re: HELPPPP

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?

# Re: HELPPPP

if you are not here to help why respond though?

# Re: HELPPPP

@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.

# Re: HELPPPP

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

# Re: HELPPPP

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

# Re: HELPPPP

are you seeing the picture?

# Re: HELPPPP

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

# Re: HELPPPP

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?

# Re: HELPPPP

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

# Re: HELPPPP

Apparently I don't understand the question, sorry.