Siouxsie
Moderator
My knowledge of excel is fairly basic so I'm hoping someone can help me.
I have 2 spreadsheets both containing lists of the same items.
The description of these items is 3 words eg:
A1 = blue, B1 = coat, C1 = large
A2 = green, B2 = jumper, C2 = medium
A3 = green, B3 = coat, C2 = small
Spreadsheet 2 also has a price in column D
The items are in different orders on each spreadsheet, in fact on spreadsheet 1 they are split over a number of workbooks, whereas on 2 they are in one long list.
What I need to do is find the matching item on spreadsheet 2 and drop the price into column D in spreadsheet 1.
So what formula do I need to put into column D on 1 so that it retrieves the correct price from 2?
All help gratefully received.
I have 2 spreadsheets both containing lists of the same items.
The description of these items is 3 words eg:
A1 = blue, B1 = coat, C1 = large
A2 = green, B2 = jumper, C2 = medium
A3 = green, B3 = coat, C2 = small
Spreadsheet 2 also has a price in column D
The items are in different orders on each spreadsheet, in fact on spreadsheet 1 they are split over a number of workbooks, whereas on 2 they are in one long list.
What I need to do is find the matching item on spreadsheet 2 and drop the price into column D in spreadsheet 1.
So what formula do I need to put into column D on 1 so that it retrieves the correct price from 2?
All help gratefully received.