Need to check two columns to get the value of a third one

[necalabria]

Hello friens.

1. I have a sheet with 6 columns, A to F, and 50 rows.

2. Each cell in column F, is formulated to calculate its value depending on the values the User enters in Column D or Column E; D would be added E would be substracted.

3. Range(F50) is where I need to show the last calculated value in Range(F1:F49), which I think should be detectec by testing the last non blank cell in Range(D1:D49) or in Range(E1:E49).

4. I have tryed using Vlookup, Index/Match and Lookup, but I was not able to do it.

5. I could not get the sheet attached. Apologies.

Thanks in advance.


Nelson

[Aardigspook]

Try this:

Please Login or Register  to view this content.

It checks the last non-blank row in the range D1:E49 and returns the value on that row, two columns to the right of D (so F).


p.s. if you need to attach a file in future, click 'Go Advanced' under the post/reply box then scroll down to 'Manage Attachments'.

[necalabria]

Hi Aardigspook,

Thank you so much.

Unfortunately, your formula did not work. It always shows the value in F1.

Anyway, somehow it gave me some, lets say "feeling", and I ended up with the formula that's below. It does the job.

Anyway, thank you.

Nelson

[Aardigspook]

Unfortunately, your formula did not work. It always shows the value in F1.

Ah, sorry, I forgot one essential part of it - it's an array formula, so needs to be entered using Ctrl-Shift-Enter not just Enter. Then it will return the F value on the correct row. Sorry about that.

Anyway, I'm glad you worked out the other formula which works for you.