• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Use of Indirect in Excell

For the following function
IF(Sheet1!M6>0,Sheet1!M6," ")

Can you please tell me what the exact format would be for the use of Indirect to replace 6 in the expression above with a value that is in cell U5.

  • 3
1 Solution
Hi DavidMyers,

Use this

If(Indirect("Sheet1!M"&U5)>0;Indirect("Sheet1!M"&U5);" ")

Value must be in cell "U5"

Hope this is it,

Didn't see your other question directly connected to this one and the answer given by cri.

It wasn't necessary to ask a new question, you should just have added a comment to the first question you asked, and I'm sure cri would have given you the satisfactory answer.

In fact the answer I gave is exactly the same as cri's, I just introduced the right characters on the right place responding to your new question.

If this answers your needs, two options:

    1. Give cri the points and ask EE to delete this question
    2. Give us both the points if you feel we both helped

If you're still not 100% satisfied, add your additional questions as a comment in one of both questions and ask to delete the other one.

Bye, Geert

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now