Forum Discussion
Solved
How to find data on another sheet by value that isn't exactly same?
Hello,
I need to look up data from another sheet with other value that isn't exactly same. And can it be done automatically on the right shell?
Green is the place where i need the new data and yellow is the look up value.
File:Example
For the first x:
=XLOOKUP(SUBSTITUTE(A11,"A ",""),asbuilts_Brobölentie_2024_03_20T12_34_07_049Z[refName],asbuilts_Brobölentie_2024_03_20T12_34_07_049Z[x])
5 Replies
For the first x:
=XLOOKUP(SUBSTITUTE(A11,"A ",""),asbuilts_Brobölentie_2024_03_20T12_34_07_049Z[refName],asbuilts_Brobölentie_2024_03_20T12_34_07_049Z[x])- Thank you!
Do you know how can i add them automatically on right row?
