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

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

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?"

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