|
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 |
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 |
| All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com