# Thread: Compare values via formula (2000)

1. ## Compare values via formula (2000)

I have a spreadsheet that has two sheets in it. The first sheet has codes and descriptions in columns one and two, with associated values in column three. The first sheet also has a specific sort order and rows 1-50 are the key ones.

The second sheet has similar information to the first. The differences are: different values in column three and a different sort order.

Based on the sort order of the first sheet (looking at rows 1-50), I need to compare the values in column three of both sheets and create a chart of the values with the codes and descriptions as category/axis labels.

In other words, I need to look at the codes in the first column of both sheets to see if a code in some row of the second sheet matches a code in rows 1-50 of the first sheet. If it does, I need to get the values of the corresponding third column for both sheets and create a chart showing those values.

If possible, I

2. ## Re: Compare values via formula (2000)

Lets say the 1-50 list is on sheet2, cells A1:C50.

In cell D1 of sheet1, enter this formula:

=VLOOKUP(A1,Sheet2!\$A\$1:\$C\$50,3,False)

3. ## Re: Compare values via formula (2000)

Perfect!

Thanks very much.
Jim

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•