matching values in columns to update prices
 

Hi,

I have two list of products in the following format:

LIST 1

PROD ID PRICE
0998552 £1.04
0998553 £1.10
0998963 £2.95
0997542 £3.60
0997544 £9.60

LIST 2

PROD ID PRICE
0998963 £3.50
0998552 £1.50
0997544 £9.80
0998553 £1.50
0997542 £3.90


Both lists are in a different order, I need to transpose the prices
from list 2 to another column on list 1 so that the price matches the
PROD ID in each list. Any help greatly appreciated.. Each list
contains approx 400 products.


Thanks in advance for any help!!

Jon

matching values in columns to update prices
 

Hi,

In this case List 1 is in A1 - B6 and list 2 is ni I1 - J6.
Put this in C2 and drag down and it will copy the prices from list2

=VLOOKUP(A2,$I$2:$J$6,2,FALSE)

Mike

"jonno" wrote:

Hi,

I have two list of products in the following format:

LIST 1

PROD ID PRICE
0998552 £1.04
0998553 £1.10
0998963 £2.95
0997542 £3.60
0997544 £9.60

LIST 2

PROD ID PRICE
0998963 £3.50
0998552 £1.50
0997544 £9.80
0998553 £1.50
0997542 £3.90


Both lists are in a different order, I need to transpose the prices
from list 2 to another column on list 1 so that the price matches the
PROD ID in each list. Any help greatly appreciated.. Each list
contains approx 400 products.


Thanks in advance for any help!!

Jon

matching values in columns to update prices
 

On 16 May, 09:42, Mike H wrote:
Hi,

In this case List 1 is in A1 - B6 and list 2 is ni I1 - J6.
Put this in C2 and drag down and it will copy the prices from list2

=VLOOKUP(A2,$I$2:$J$6,2,FALSE)

Mike



"jonno" wrote:
Hi,

I have two list of products in the following format:

LIST 1

PROD ID * PRICE
0998552 * *£1.04
0998553 * *£1.10
0998963 * *£2.95
0997542 * *£3.60
0997544 * *£9.60

LIST 2

PROD ID * PRICE
0998963 * *£3.50
0998552 * *£1.50
0997544 * *£9.80
0998553 * *£1.50
0997542 * *£3.90

Both lists are in a different order, I need to transpose the prices
from list 2 to another column on list 1 so that the price matches the
PROD ID in each list. *Any help greatly appreciated.. Each list
contains approx 400 products.

Thanks in advance for any help!!

Jon- Hide quoted text -

- Show quoted text -

Thanks for the attempt - although I get the following error when
attempt it:
"Data on the Clipboard is not the same size and shape as the selected
area. Do you want to paste the data anyway?"

matching values in columns to update prices
 

On 16 May, 09:54, jonno wrote:
On 16 May, 09:42, Mike H wrote:





Hi,

In this case List 1 is in A1 - B6 and list 2 is ni I1 - J6.
Put this in C2 and drag down and it will copy the prices from list2

=VLOOKUP(A2,$I$2:$J$6,2,FALSE)

Mike

"jonno" wrote:
Hi,

I have two list of products in the following format:

LIST 1

PROD ID * PRICE
0998552 * *£1.04
0998553 * *£1.10
0998963 * *£2.95
0997542 * *£3.60
0997544 * *£9.60

LIST 2

PROD ID * PRICE
0998963 * *£3.50
0998552 * *£1.50
0997544 * *£9.80
0998553 * *£1.50
0997542 * *£3.90

Both lists are in a different order, I need to transpose the prices
from list 2 to another column on list 1 so that the price matches the
PROD ID in each list. *Any help greatly appreciated.. Each list
contains approx 400 products.

Thanks in advance for any help!!

Jon- Hide quoted text -

- Show quoted text -

Thanks for the attempt - although I get the following error when
attempt it:
"Data on the Clipboard is not the same size and shape as the selected
area. *Do you want to paste the data anyway?"- Hide quoted text -

- Show quoted text -

sorry my mistake, IT WORKS!! Thanks very much. I had copied and
pasted the information into excel all in the same cell!

Thanks again for your help Mike