Recherchev and formula

Copper 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! :smiling_face_with_smiling_eyes: 

2 Replies
best response confirmed by mariegainche1545 (Copper 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!