| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup by rows and columns
Hi All
I have workbook (Products) with sheets(January, Febr,March.........) In row 1 I have date(C1=1,D1=2......) In column A I have Part numbers.(part1, part2, part3,....) In another workbook(Reports) I have sheets by weekly. I like to create formula to find data from "Products". How many produced part1 on the 03. march or part2 on the 01. june ... Part numbers on the columnA and date on the row20. I hope that not very absurd question. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
