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])
Thank you!
Do you know how can i add them automatically on right row?
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.
You have to put the formulas in the cells you want them.
If you want some kind of automatism then you need VBA and someone else to write the code.