S
Susan
I have 2 spreadsheets.
I want to use a field value in S1 to lookup in S2 for a match.
When the match is TRUE, I want the value in S2 of field xyz, pasted into
field abc of S1.
I have =LOOKUP(C2,test.csv'!$C$2,test.csv'!$D$2)
When the match is TRUE it works like a charm, but when it is FALSE, it
pastes the closest value
I would like the field to remain blank if there is no match
~ Susan
I want to use a field value in S1 to lookup in S2 for a match.
When the match is TRUE, I want the value in S2 of field xyz, pasted into
field abc of S1.
I have =LOOKUP(C2,test.csv'!$C$2,test.csv'!$D$2)
When the match is TRUE it works like a charm, but when it is FALSE, it
pastes the closest value
I would like the field to remain blank if there is no match
~ Susan