I
Iriemon
I am trying to write a vlookup that looks in more than one column for the
data, is this possible?
Col a Col b Col c col d
1 a 1 a
2 b
3 c
4 d
How do I get a vlookup or other function to find the "2"?
=vlookup(a10,a1:b4;c1:d4,2,false) where a10=2 doesn't work.
data, is this possible?
Col a Col b Col c col d
1 a 1 a
2 b
3 c
4 d
How do I get a vlookup or other function to find the "2"?
=vlookup(a10,a1:b4;c1:d4,2,false) where a10=2 doesn't work.