Matching data from different worksheets

[melanie-h]

Hi

I have 2 worksheets with different data concerning mutual funds. on one sheet i have sales figures, fund age and fund performance & on the other sheet i have fund fees. The funds are identifed on each worksheet using an ISIN code. The list of ISIN codes on each worksheet (around 500) are not exactly the same so I cant just sort and put them together. Is there a way to match fund fee data with the other fund data for the ISIN codes which do appear on both sheets?

Thanks for your help !

mel

[samprince]

se VLookup & Sedol Codes \-:

Sort your ISIN Codes on the first work sheet ascending.

In B2

=VLOOKUP(A2,Sheet1!A:x,2) Returns the value in column 2 alongside the ISIN that matches A2.

in C2 you would change the 2 to 3 and so on further additional data.

Let me know if ok.