Recherchev and formula

New Contributor



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)




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


And how could I do it on a different way? 


Thanks a lot!  

2 Replies
best response confirmed by mariegainche1545 (New Contributor)


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!