Recherchev and formula

New Contributor

Bonjour,

 

comment puis-je faire une recherchev sur des cellules avec formules sans les copier en valeur (car ce n'est pas le but du tout)

 

HI, 

 

Can I do a xlookup on a table with formulas fields? 

How? 

And how could I do it on a different way? 

 

Thanks a lot!  

2 Replies

@mariegainche1545 

VLOOKUP and XLOOKUP work fine with columns that contain formulas. If you experience a problem, what is it?

@Hans Vogelaar thank you for the answer.

 

I think there are issues in the tables so. I'm gonna investigate and if I have any other problems with that I will explicite them so now that I'm sure we can do it!