Hello,
I am trying to search for value in row A of one sheet in the col A or C of a second sheet and return the value of col K from that second sheet. The formula below works when it's just one col I am searching for:
=XLOOKUP(A4,'Station 3'!$A$3:$A$2001,'Station 3'!$K$3:$K$2001)
But when I want to search in multiple cols using the formula below, I change the range and instead I get a #VALUE!.
=XLOOKUP(A4,'Station 3'!$A$3:C$2001,'Station 3'!$K$3:$K$2001)
Sorry if I am making a basic error here....
Bookmarks