column matching
=VLOOKUP(A2,D:F,2,0) will retrieve data from column E if A2 matches D
=VLOOKUP(A2,D:F,3,0) will retrieve data from column F if A2 matches D
To allow for no match:
=IF(ISNA(VLOOKUP(A2,D:F,2,0)) ,"",VLOOKUP(A2,D:F,2,0) ) will return a blank
HTH
"danm5644" wrote:
I was wondering if there is some way that I can match or do an if then
function to match data from columns.
For Instance if you had:
One set of columns another set of columns
A B C D E
F
Style WTD MTD Style OH OO
145 5 19 153 7 12
150 6 12 154 5 9
153 5 10 150 4 9
I would like to see if I can sort the first set and say if style from column
A = column D then move E and F.
Does this make any sense? Sorry it is difficult to explain but I get
selling information from a company on 2 different reports and there are 100's
of styles if I could match them in some other way it would be helpful.
Currently I sort by style # and then cut and paste until everything matches
and that takes a lot of time.
Thanks,
|