K

#### Kat

C, D) Sheet 1, Sheet 2, Sheet 3, Sheet 4 and Sheet 5.

Each sheet pertains to different customers except, Sheet 1 is my reporting

sheet to find the differences.

On each sheet:

Column A - Text (part numbers, Alpha sorted)

Column B - Part description

Column C - UPC #

Column D - Price per 100

Sheet 2 has the most info it in. All part numbers (columnA) listed in

Alphabetic order from Cell A2 - A4675, it is the most extensive price sheet.

Sheets 3, 4 & 5 have anywhere from 309 - 485 rows of part numbers.

Sheet 1 has all part numbers listed alphabetic order in Column A starting in

Cell A2

I want to compare the price each customer gets (column d) and report that on

sheet 1. Here is the formula I'm trying to use in sheet 1, B2:

=LOOKUP(A2,Sheet2!$A$2:$A$309,Sheet2!$D$2:$D$309)

The formula changes for each row to "lookup(A3...", "lookup(A4..." etc.

My problem is that if the formula finds a price it reports it fine but the

next row doesn't have a price and it repeats the price from the row above

until it finds another difference. Any suggestions to a better formula or

what might be wrong with mine?

Any help is greatly appreicated.

Thanks in Advance

Kat