Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Seeking the data in two columns

  Asked By: Lisa    Date: Nov 06    Category: MS Office    Views: 620
  

I've got two columns of data (number).
There are a correspondence between both and each of these are sorted
by ascendant.
I would like to fill a third column which contains data of the same
kind of the second column by replacing them by their correspondent.
But I don't want to use "vlookup" because I type only a few data in
the two first columns.
I think there is a method that Excel understands the correspondence
between the two first columns and seek the correspondence of the
following number.
Here is one example to help you to understand:
A B
1 1148
2 1149
3 1150
...

In the columns C, there are:
C
1178
1167
1194
...

Is it possible to avoid to type all the data in the two first columns?



Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Seeking the data in two columns Or get search suggestion and latest updates.




Tagged: