CODEWITHSUNDEEP
excelexcel-2013
yakitori
yakitori

Reputation: 37

EXCEL 2013 : set the name of variable from value of cells

I have set the name P1A_FO_DESIGN on a cell A1 that countains the value 5.12 I have set another cell C10 with this value: =("="&A10&"_"&B10&"_"&C8)

A10 contains P1A

B10 contains FO

C8 contains DESIGN

the value of C10 is =P1A_FO_DESIGN but I would like it to display 5.12 How do I acheive it please? Regards

Upvotes: 3

Views: 91

Answers (1)

JNevill
JNevill

Reputation: 50219

Use =INDIRECT() formula:

=INDIRECT(A10&"_"&B10&"_"&C8)

This will evaluate to =INDIRECT("P1A_FO_DESIGN") Which will further evaluate to point to the cell with that Name.

Upvotes: 4

Related Questions