Recherchev and formula

[mariegainche1545]

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

[#2 · Accepted solution]

@mariegainche1545 

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

[#3]

@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!