| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate Sku No in Sheet 1 against Sheet 2
I have a master Inventory file with a full item list (sheet1)which has 3600
SKUs by item then color. I am creating a cheat sheet (sheet2) which has 300 SKUs setup by item only that I want to update the pricing from the master file. Currently the cheat sheet points to the cell that has the pricing for 1 of the item I want to use. The issue I have is some of the line numbers getting deleted in the master file which causes sheet2 to grab the next item in line causing MASS CONFUSION. I have now included a SKU column in sheet2 which I want to tie to the SKU number in the master file. Sorry if this is so confusing.... I just want the SKU number of sheet2 to validate using the SKU number of sheet1 before grabbing the pricing column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
