| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I lookup values from rows and columns Simultaneously
Am trying to create a fomulae that will look up data dependant on rows and
columns. E.g In the lookup range cells A1:A10 contains diffrent item codes and columns B1:D1 contains months i.e Jan-05, April-05, Aug-05 (being datevalue labels). Cells B2:D10 contain the data dependant e.g rates. On the output sheet which contains item codes (A1:A10) and B1:M1 the months of the year (Jan to Dec-05). For cells B1:M10 it should be pick rates for the months that are less or equal to the column month (B1:M1) and itemcode as per column A. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions | |||
Threaded Mode
