Combined functions

H

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,
 
H

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
 
J

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
 
Top