Home > Back-end >  problem of syntax in function indirect hlookup
problem of syntax in function indirect hlookup

Time:03-04

I did this function in excel, and it works perfectly :

=RECHERCHEH(H$3;INDIRECT("'"&parametre!$B$3&"["&parametre!$B$4&"]"&parametre!$B$5&"'!$1:$200");LIGNE();0)

But when I try to replace $1:$200 per

=RECHERCHEH(H$3;INDIRECT("'"&parametre!$B$3&"["&parametre!$B$4&"]"&parametre!$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("'"&parametre!$B$3&"["&parametre!$B$4&"]"&parametre!$B$5&"'!"&RECHERCHEV(C5;parametre!$B$7:$C$11;2));LIGNE();0)
  • Related