V
varun
COLUMN 1 COLUMN2 TARGET cloumn3 column4 >TARGET
A 20 A 20 AA
B 30 B 30 BB
S 23 F 24 FF
D 23 D 23 DD
G 12 J 65 JJ
F 24 H 25 HH
D 23
A 20
S 23
D 20
F 24
G 12
H 25
J 65
K 65
L 43
J 65
G 12
In the above column named 'TARGET' i want to apply Vlookup. for eg:-( where
A=20 in COLUMN1 & COLUMN2, return 'AA' from '>TARGET' in 'TARGET')
similarly for all.
i hope i am clear with my question.
thanks,
varun
A 20 A 20 AA
B 30 B 30 BB
S 23 F 24 FF
D 23 D 23 DD
G 12 J 65 JJ
F 24 H 25 HH
D 23
A 20
S 23
D 20
F 24
G 12
H 25
J 65
K 65
L 43
J 65
G 12
In the above column named 'TARGET' i want to apply Vlookup. for eg:-( where
A=20 in COLUMN1 & COLUMN2, return 'AA' from '>TARGET' in 'TARGET')
similarly for all.
i hope i am clear with my question.
thanks,
varun