Question on Linked cell formulae

[Mirisage]

Hi Excel Forum,

In the attached Excel file, “Input data” tab is having input data to create a “Decision Tree” like structure in the other tab named “Decision Tree”.

“Input data” sheet is monthly created by a SAS code when I have to populate the values of cells highlighted by blue color.


There are over 1,000 nodes in the tree (ID_11, ID_21, ID_22 etc.) that I have to populate each month.

I am going to link each blue cell into the corresponding cell in “Input data” sheet at least to semi automate the populating work.

The embedded formulae are as simple as this:
='Input data'!B2

Do I need to add “iserror” terms etc. into this formulae to capture unexpected values in the “Input data” sheet?
Thanks
Mirisa

[FDibbins]

This may help speed up your linking...
=IFERROR(INDEX('Input data'!$B$2:$E$3,1,MATCH(SUBSTITUTE(F4," ","_"),'Input data'!$B$1:$E$1,0)),"")

copy this exact same formula to the row below, and change the ,1, (bolded) to ,2,

[Punnam]

hi,

Try this

Please Login or Register  to view this content.

for total Count

Please Login or Register  to view this content.

for total money

Remove the " _ " in your data sheet for both the ID & Total Count & Total Money

Punnam

[FDibbins]

@ Punnam, if this is a SAS import (as mentioned), they may not be able to remove the "_", tats why I built that into my formula

[Mirisage]

Hi Ford and Punnam,

Many thanks to both of you.

Hi Ford, Many thanks for the last SAS clarification too.
Mirisa