Excel - Referencing a named range Cell (I'm sure this is simple I'm just stuck)

Question

I have a named cell called Crew5, and that cell has a value of $457.00
When I type the name in a formula, there are no problems:
=40*Crew5
answer is $18,200

But if I want to call the value out of another cell that has the word Crew5 typed in it. I can't get it to pick up the value associated with it. I know =Crew5 will work. Lets say
I have Typed the word Crew5 in Cell C63, and in another cell like cell H78, I want to use the value of that in a formula, I type in =text(indirect("C63") it does give me Crew5. Then I modify it to say =value(text(indirect("C63"))*40, I get #value!   
but I want the value of Crew5 in that formula.

What am I missing?

thanks in advance

Answer 1

Hi @Kendall, Steven

Please refer to Viorel's suggestion.

• If you want to get the text that is displayed in cell C63 instead of looking for cell reference instructions in C63. Please use the formula =indirect("C63").
• If you want to look for the cell reference being queried in C63, the formula is =indirect(C63).

Any misunderstanding, please feel free to post back.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---