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

Kendall, Steven 20 Reputation points

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

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
561 questions
{count} votes

Accepted answer
  1. Emily Hua-MSFT 26,921 Reputation points

    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.

0 additional answers

Sort by: Most helpful