Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get data from one cell based on the value in another?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing a cell based on the value of another cell (INDIRECT data) without macros | About this forum | |||
Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions |