Hello all,
My query is a little more in depth. I have two spread sheets one is named
Retail Price list and the other is named Home Accents.

In the Price List there are 5 columns of data, Item #, Page #, Short Desc,
Unit of Sale, Price

In the Home Accents there are 4 columns of data, Section Text, Product Ref#,
Page #, Short Desc, Long Desc.

Ok, the Product REF and Item # are the same data. The Short Desc is the
same data. All the rest of the fields are ignored.

In the Home Accents sheet the Short Desc is Blank and I would like it filled
with the data that is in Retail Price(Short Desc), I would need to compare
HomeAccess(ProductREF) with RetailPrice(Item) and if it matches, write the
data from RetailPrice(ShortDesc) to HomeAccess(ShortDesc). The trick here is
that neither spread sheet match row for row, and in some instances the
HomeAccess(ProductREF) is not contained in the RetailPrice at all, or it may
be contained a few lines down.

In VB I could write a routine that would read all the lines in from
HomeAccess and write them back out with the data from PriceList after doing a
INST and matching the ProductREF with Item#

Example of the data is
[SectText] [Item#] [Pg#] [Short Desc ] [Long Desc]
Home Accents 32439 2 Looking as though it came...

[Item#] [Pg#] [SHORT DESC] [UNIT]
[PRICE]
32439 2 15" PILLOWCASE W/CUSHION 1 EA 29.95