L
Lisa
I have been asked to come up with a formula the will look at 3 columns of
data and return any matches in a 4th column. It needs to look at the whole
column and not just the row. So basically if the same number is found in A,
B, or C, put that number in D. (Excel 2000)
A B C D
IMS Hosp Cafe
4071 4071 4071
4075 4076 4075
4076 4079 4076
4078 4082 4078
4079 4178 4079
4082 5250 4082
5250 5251 5250
5251 5256 5251
5256 5258 5256
5257 5259 5257
5258 5260 5258
5260 5261 5260
5261 5262 5261
5262 5263 5262
5263 5264 5263
5264 5273 5264
5273 5274 5273
5274 5275 5274
5274 5276 5274
data and return any matches in a 4th column. It needs to look at the whole
column and not just the row. So basically if the same number is found in A,
B, or C, put that number in D. (Excel 2000)
A B C D
IMS Hosp Cafe
4071 4071 4071
4075 4076 4075
4076 4079 4076
4078 4082 4078
4079 4178 4079
4082 5250 4082
5250 5251 5250
5251 5256 5251
5256 5258 5256
5257 5259 5257
5258 5260 5258
5260 5261 5260
5261 5262 5261
5262 5263 5262
5263 5264 5263
5264 5273 5264
5273 5274 5273
5274 5275 5274
5274 5276 5274