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...
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])
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?I have multiple point data's like this in one work sheed and i need to get function on highlighted spot based on the ***** KC 14 ****** that is always first row in point data.
