Replacing data in one column with another

[babypink2807]

Hi

I have a column which has the following numbers

01
02
04
05

These numbers represent a depot

01 Leeds
02 Manchester
04 Huddersfield
05 Lincoln

I need Excel to look up the 01 and replace it with Leeds

Both sets of data are in a different table the old way has been to do CTR and F which is becoming a pain as we are increasing depots etc. SO would prefer that I can say if its 01 please replace with Leeds

Thank you

 

[Fluff]

Have a look at the Vlookup function.
There's a tutorial on it here
https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/

 

[The_Macrotect]

Hey there!

VLOOKUP will be the way to go. It would look something like this. H1:I5 is the lookup table. Column A is the column with the numbers you described in your post. Column B is the output from the VLOOKUP function.

Excel 2007 32 bit

	A	B	C	D	E	F	G	H	I	J
1	02	Manchester						Lookup:
2	01	Leeds						01	Leeds
3	04	Huddersfield						02	Manchester
4	04	Huddersfield						04	Huddersfield
5	05	Lincoln						05	Lincoln
6	01	Leeds
7	05	Lincoln
8	05	Lincoln
9	05	Lincoln
10	01	Leeds
11	01	Leeds
12	05	Lincoln
13	02	Manchester
14	04	Huddersfield
15	02	Manchester

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =VLOOKUP([COLOR=rgb(255]A1,$H$2:$I$5,2,[/COLOR]) B2 =VLOOKUP([COLOR=rgb(255]A2,$H$2:$I$5,2,[/COLOR]) B3 =VLOOKUP([COLOR=rgb(255]A3,$H$2:$I$5,2,[/COLOR]) B4 =VLOOKUP([COLOR=rgb(255]A4,$H$2:$I$5,2,[/COLOR]) B5 =VLOOKUP([COLOR=rgb(255]A5,$H$2:$I$5,2,[/COLOR]) B6 =VLOOKUP([COLOR=rgb(255]A6,$H$2:$I$5,2,[/COLOR]) B7 =VLOOKUP([COLOR=rgb(255]A7,$H$2:$I$5,2,[/COLOR]) B8 =VLOOKUP([COLOR=rgb(255]A8,$H$2:$I$5,2,[/COLOR]) B9 =VLOOKUP([COLOR=rgb(255]A9,$H$2:$I$5,2,[/COLOR]) B10 =VLOOKUP([COLOR=rgb(255]A10,$H$2:$I$5,2,[/COLOR]) B11 =VLOOKUP([COLOR=rgb(255]A11,$H$2:$I$5,2,[/COLOR]) B12 =VLOOKUP([COLOR=rgb(255]A12,$H$2:$I$5,2,[/COLOR]) B13 =VLOOKUP([COLOR=rgb(255]A13,$H$2:$I$5,2,[/COLOR]) B14 =VLOOKUP([COLOR=rgb(255]A14,$H$2:$I$5,2,[/COLOR]) B15 =VLOOKUP([COLOR=rgb(255]A15,$H$2:$I$5,2,[/COLOR]) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Let me know if this isn't quite what you were looking for, and we can explore more options.