Prev: Help with Text and Dates
Next: Compare worksheet data
From: Katerinia on 31 Mar 2010 10:20
i have a list of job codes in Sheet 1 column V that need to be updated with
new codes listed in Sheet 2 column B.

Sheet 2 column A contains the old job code, column b the new one.

How do I reference on Sheet 1 look at column v, find the matching job code
in Sheet 2 column A and return the value in Sheet 2 Column B.
From: trip_to_tokyo on 31 Mar 2010 10:36
EXCEL 2007

I have just put up a file for you at:-

http://www.pierrefondes.com/

Item number 83 (towards the top of the home page at time if posting).

I think that this gives you what you want.

If you agree please hit Yes.

Thanks.

"Katerinia" wrote:

> i have a list of job codes in Sheet 1 column V that need to be updated with
> new codes listed in Sheet 2 column B.
>
> Sheet 2 column A contains the old job code, column b the new one.
>
> How do I reference on Sheet 1 look at column v, find the matching job code
> in Sheet 2 column A and return the value in Sheet 2 Column B.
From: Katerinia on 31 Mar 2010 10:51
company limits internet access. Can you post the answer here?

"trip_to_tokyo" wrote:

> EXCEL 2007
>
> I have just put up a file for you at:-
>
> http://www.pierrefondes.com/
>
> Item number 83 (towards the top of the home page at time if posting).
>
> I think that this gives you what you want.
>
> If you agree please hit Yes.
>
> Thanks.
>
> "Katerinia" wrote:
>
> > i have a list of job codes in Sheet 1 column V that need to be updated with
> > new codes listed in Sheet 2 column B.
> >
> > Sheet 2 column A contains the old job code, column b the new one.
> >
> > How do I reference on Sheet 1 look at column v, find the matching job code
> > in Sheet 2 column A and return the value in Sheet 2 Column B.
From: trip_to_tokyo on 31 Mar 2010 11:14
EXCEL 2007

This is what I have done:-

1. Sheet1

V1 Old Job Code
V2 A
V3 B
V4 C
V5 D
V6 E


W1 New Job Code
W2 =VLOOKUP(V2,JobCodes,2)
W3 =VLOOKUP(V3,JobCodes,2)
W4 =VLOOKUP(V4,JobCodes,2)
W5 =VLOOKUP(V5,JobCodes,2)
W6 =VLOOKUP(V6,JobCodes,2)

2. Sheet2

A1 Old Job Code
A2 A
A3 B
A4 C
A5 D
A6 E


B1 New Job Code
B2 1
B3 2
B4 3
B5 4
B6 5


Sheet2 cells A 2 to B 6 have a Range Name of JobCodes

Please hit yes if my comments have helped.

Thanks.



"Katerinia" wrote:

> company limits internet access. Can you post the answer here?
>
> "trip_to_tokyo" wrote:
>
> > EXCEL 2007
> >
> > I have just put up a file for you at:-
> >
> > http://www.pierrefondes.com/
> >
> > Item number 83 (towards the top of the home page at time if posting).
> >
> > I think that this gives you what you want.
> >
> > If you agree please hit Yes.
> >
> > Thanks.
> >
> > "Katerinia" wrote:
> >
> > > i have a list of job codes in Sheet 1 column V that need to be updated with
> > > new codes listed in Sheet 2 column B.
> > >
> > > Sheet 2 column A contains the old job code, column b the new one.
> > >
> > > How do I reference on Sheet 1 look at column v, find the matching job code
> > > in Sheet 2 column A and return the value in Sheet 2 Column B.
From: Katerinia on 31 Mar 2010 12:32
i need to return the value, not the reference.

"trip_to_tokyo" wrote:

> EXCEL 2007
>
> This is what I have done:-
>
> 1. Sheet1
>
> V1 Old Job Code
> V2 A
> V3 B
> V4 C
> V5 D
> V6 E
>
>
> W1 New Job Code
> W2 =VLOOKUP(V2,JobCodes,2)
> W3 =VLOOKUP(V3,JobCodes,2)
> W4 =VLOOKUP(V4,JobCodes,2)
> W5 =VLOOKUP(V5,JobCodes,2)
> W6 =VLOOKUP(V6,JobCodes,2)
>
> 2. Sheet2
>
> A1 Old Job Code
> A2 A
> A3 B
> A4 C
> A5 D
> A6 E
>
>
> B1 New Job Code
> B2 1
> B3 2
> B4 3
> B5 4
> B6 5
>
>
> Sheet2 cells A 2 to B 6 have a Range Name of JobCodes
>
> Please hit yes if my comments have helped.
>
> Thanks.
>
>
>
> "Katerinia" wrote:
>
> > company limits internet access. Can you post the answer here?
> >
> > "trip_to_tokyo" wrote:
> >
> > > EXCEL 2007
> > >
> > > I have just put up a file for you at:-
> > >
> > > http://www.pierrefondes.com/
> > >
> > > Item number 83 (towards the top of the home page at time if posting).
> > >
> > > I think that this gives you what you want.
> > >
> > > If you agree please hit Yes.
> > >
> > > Thanks.
> > >
> > > "Katerinia" wrote:
> > >
> > > > i have a list of job codes in Sheet 1 column V that need to be updated with
> > > > new codes listed in Sheet 2 column B.
> > > >
> > > > Sheet 2 column A contains the old job code, column b the new one.
> > > >
> > > > How do I reference on Sheet 1 look at column v, find the matching job code
> > > > in Sheet 2 column A and return the value in Sheet 2 Column B.
 |  Next  |  Last
Pages: 1 2
Prev: Help with Text and Dates
Next: Compare worksheet data