Hi,

You need to use VLOOKUP(A1,Table,2,false)

Where Table is a range the first column containing the list of company
names, the second containing the 4 digit number you want.

--
Cheers,
Shane Devenshire


"Finding_Facts_NC" wrote:

I have a column containing three digit numbers and four digit numbers. I
need to replace the three digit numbers with the first four digit number
listed below them.
Here's an example of the numbers listed in column "B" and what the result
should look like in column "C"

A B C
Co Name 1 119 5530
Co Name 1 449 5530
Co Name 1 5530 5530
Co Name 2 119 5513
Co Name 2 5513 5513
Co Name 3 119 5540
Co Name 3 449 5540
Co Name 3 559 5540
Co Name 3 5540 5540

There are over 6,000 rows. Is there a formula that will help me do this?