Use cell-adress as reference when Xlookup not found

[Geir Hogstad]

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

[#2 · Accepted solution]

@Geir Hogstad 

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]

Thank you @Sergei Baklan perfect. It worked. I ended up with using IFERROR, if the Xlookup got an error, I selected value from a cell.

- Geir

[#4]

@Geir Hogstad , you are welcome