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

Thanks
0
DavidMyers
Asked:
DavidMyers
  • 3
1 Solution
 
calacucciaCommented:
Hi DavidMyers,

Use this

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


Value must be in cell "U5"

Hope this is it,

Gert
0
 
calacucciaCommented:
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.

0
 
calacucciaCommented:
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
0

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