Forum Discussion
Solved
Use cell-adress as reference when Xlookup not found
Hi, Can i use reference to a cell value when Xlookup is not found? This returns an error (#Value) =Xlookup(U2#;Konteringsbilag!K:K&Konteringsbilag!J:J&Konteringsbilag!S:S;Konteringsbilag!O:O...
Geir, you need to push evaluation for the reference, formula like
=Xlookup(U2#;Konteringsbilag!K:K&Konteringsbilag!J:J&Konteringsbilag!S:S;Konteringsbilag!O:O;$Y$2&"")
shall work
Geir, you need to push evaluation for the reference, formula like
=Xlookup(U2#;Konteringsbilag!K:K&Konteringsbilag!J:J&Konteringsbilag!S:S;Konteringsbilag!O:O;$Y$2&"")
shall work
Thank you SergeiBaklan perfect. It worked. I ended up with using IFERROR, if the Xlookup got an error, I selected value from a cell.
- Geir
Hogstad_Raadgivning , you are welcome
