How to use results of a vlookup function cell in a different cell formula

Welcome to the forum!

What exactly do you mean by, "use it in another cell, O2, as the value "C2:C200" in the function =SUMPRODUCT(F2:200,C2:C200)"? What sort of value does the VLOOKUP formula return?

No, sorry! Are you able to provide a sample workbook?

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

I'm sorry that you think I am "making too much of this". I hope somebody else understands what you are trying to do, but I'm afraid I don't.

Originally Posted by bendover4me

i Think you are making too much of this.

No, not really, Im not sure I understand what you want, either. Keep in mind that generally, we have no clue what you are working wih, or what you actually want, so to avoid guessing and waste both your time and the responder, we often ask for a sample WB so we can see exactly where you are.

Wioth that said, that formula...
=SUMPRODUCT(F2:200,C2:C200)
looks wrong anyway, I think you left out a column ref?
=SUMPRODUCT(F2:F200,C2:C200)

Formulas in excel look at what is displayed in the cell, not the underlying contents. So if you have a formula in A1 that says =B1+5, and B1 contains 10, then any other formula that references A1 will reference 15, not the formula =B10+5

I am not understanding you, either. What, exactly does the VLOOKUP(..) function return? Exactly how does this result fit into the SUMPRODUCT() function?

Reading between the lines, perhaps you are looking for the INDIRECT() function https://support.office.com/en-us/art...1-92b6306fa261 ? Perhaps your VLOOKUP(...) function returns the text string "C2:C200", in which case, you could use the INDIRECT() function inside of the SUMPRODUCT() function.

VLOOKUP() function returns "C2:C200" to a cell.
=SUMPRODUCT(F2:F200,INDIRECT(cell with VLOOKUP))

Is that what you are looking for, or am I grossly misunderstanding?