Forum Discussion
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;$Y$2)
This works perfect
=Xlookup(U2#;Konteringsbilag!K:K&Konteringsbilag!J:J&Konteringsbilag!S:S;Konteringsbilag!O:O;"Not found")
Best regards
- Geir
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
3 Replies
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
