I did this function in excel, and it works perfectly :
=RECHERCHEH(H$3;INDIRECT("'"¶metre!$B$3&"["¶metre!$B$4&"]"¶metre!$B$5&"'!$1:$200");LIGNE();0)
But when I try to replace
$1:$200
per
=RECHERCHEH(H$3;INDIRECT("'"¶metre!$B$3&"["¶metre!$B$4&"]"¶metre!$B$5&"'!RECHERCHEV(C5;parametre!$B$7:$C$11;2)");LIGNE();0)
it doesn't work.
when I isolate my function rechercheV, I got it :
=RECHERCHEV(C5;parametre!$B$7:$C$11;2)
and it returns me :
AF:BE
So i try to put in my function rechercheV in my "big function" but no way to work for the moment
Can you help me pls ?
Thanks for reading me
CodePudding user response:
The quotes around RECHERCHEV(C5;parametre!$B$7:$C$11;2)
mean that exactly that text "RECHERCHEV(...." is being interpreted for the formula, not the value that the function would return.
Try this:
=RECHERCHEH(H$3;INDIRECT("'"¶metre!$B$3&"["¶metre!$B$4&"]"¶metre!$B$5&"'!"&RECHERCHEV(C5;parametre!$B$7:$C$11;2));LIGNE();0)