| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to set range in excel
i have got 2 sheets of excel first sheet contains the date range and price
for that date range eg. A B C 01-Apr-05 30-Apr-05 26.00 01-May-05 31-May-05 24.00 01-Jun-05 30-Jun-05 32.00 01-Jul-05 31-Jul-05 46.00 01-Aug-05 31-Aug-05 60.00 01-Sep-05 30-Sep-05 43.00 01-Oct-05 30-Oct-05 26.00 what i want in sheet 2 is A B DATE PRICE 01-Apr 26 02-Apr 26 03-Apr 26 04-Apr 26 05-Apr 26 06-Apr 26 07-Apr 26 08-Apr 26 09-Apr 26 10-Apr 26 11-Apr 26 12-Apr 26 13-Apr 26 14-Apr 26 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to set range in excel
just a VLOOKUP would do it
ig if G1 := 2-april05 then in H1: =VLOOKUP(G1,A1:C7,3,TRUE) "darsg" wrote: i have got 2 sheets of excel first sheet contains the date range and price for that date range eg. A B C 01-Apr-05 30-Apr-05 26.00 01-May-05 31-May-05 24.00 01-Jun-05 30-Jun-05 32.00 01-Jul-05 31-Jul-05 46.00 01-Aug-05 31-Aug-05 60.00 01-Sep-05 30-Sep-05 43.00 01-Oct-05 30-Oct-05 26.00 what i want in sheet 2 is A B DATE PRICE 01-Apr 26 02-Apr 26 03-Apr 26 04-Apr 26 05-Apr 26 06-Apr 26 07-Apr 26 08-Apr 26 09-Apr 26 10-Apr 26 11-Apr 26 12-Apr 26 13-Apr 26 14-Apr 26 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
| adding reference-to-range control to excel range | Excel Programming | |||
| Range.Formula and Range question using Excel Automation | Excel Programming | |||
Linear Mode
