Combined functions

[Hau]

Hi,

How can I combine these functions:

1 function:
=ROUND(($D81*Z$13)/Z$15,2); {=INDEX('87200'!
$H$2:$H$22202,MATCH($C4,'87200'!$H$2:$H$22202,))}

2 function:
=ROUND(($D81*Z$13)/Z$15,2); =VLOOKUP(C12,'86310'!
$H$4:$H$11497,1,0)


Thanks,

 

[Frank Kabel]

Hi
you may explain HOW you want them combined?

 

[Hau]

I just need to know if the following is correct:
=(ROUND(($D81*Z$13)/Z$15,2),{INDEX('87200'!
$H$2:$H$22202,MATCH($C4,'87200'!$H$2:$H$22202,))})
OR
=(ROUND(($D81*Z$13)/Z$15,2),VLOOKUP(C12,'86310'!
$H$4:$H$11497,1,0))

I am getting an error...

Regards

 

[JulieD]

Hi

what are you trying to achieve? as i can see no relationship between the
two functions .. for the functions to be combined (nested) one of the
function needs to be a parameter of the other (like the MATCH is in the
INDEX function) ... unless you mean concatenated .. where you want to see
the result of the round function followed by the result of the INDEX
function as in
=ROUND(your formula) & "-" & INDEX(your formula)

which might return something like
1.15-300

Cheers
JulieD