View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RCB RCB is offline
external usenet poster
 
Posts: 9
Default multiple values question

I have 2 cols of data and need Col 3 which inserts a value the same as column
2 but in a different range. Col 3 has been populated here to show as example.
I've been working on if statements but can't find the right one, I've tried
if and statements also. BTW I've only include Col 1 because it might help to
uniquely identify the values, but may not be necessary.

Using Excel 2003 SP3

Col 1 Col 2 Col 3
4 91610 37513
5 91610 37513
4 91611 37514
5 91611 37514
4 91612 37515
5 91612 37515
1 91613 37516
4 91613 37517
5 91613 37517
1 91614 37518
4 91614 37519
5 91614 37519
1 91615 37520
4 91615 37521
5 91615 37521
1 91616 37522
4 91616 37522
5 91616 37522
1 91617 37523
4 91617 37523
5 91617 37523
1 91618 37524
4 91618 37524
5 91618 37524
1 91619 37525
4 91619 37525
5 91619 37525
1 91620 37526
4 91620 37526
5 91620 37526
1 91621 37527
4 91621 37527
5 91621 37527


Thanks