| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up data on the next line
Hi, I've got the following information on a spreasheet:
A B C 1 Asia Measurement 0.64 2 Goal 2.0 The Cell A2 is blank. I can get Asia's C1 data (0.64) with a Vlookup, but I also want to get Asia's C2 (2.0) data without having to type "Asia" on A2. Is there a way to do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Look up data on the next line
=OFFSET(A1,1,2)
"Matheus" wrote: Hi, I've got the following information on a spreasheet: A B C 1 Asia Measurement 0.64 2 Goal 2.0 The Cell A2 is blank. I can get Asia's C1 data (0.64) with a Vlookup, but I also want to get Asia's C2 (2.0) data without having to type "Asia" on A2. Is there a way to do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Look up data on the next line
Possibly:
=INDEX(C1:C100,MATCH("Asia",A1:A100,0)+1) -- Biff Microsoft Excel MVP "Matheus" wrote in message ... Hi, I've got the following information on a spreasheet: A B C 1 Asia Measurement 0.64 2 Goal 2.0 The Cell A2 is blank. I can get Asia's C1 data (0.64) with a Vlookup, but I also want to get Asia's C2 (2.0) data without having to type "Asia" on A2. Is there a way to do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Formatting data series - line between certain data points only | Charts and Charting in Excel | |||
| Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
| inserting a line between different data | Excel Discussion (Misc queries) | |||
| My rows are off by one row, ie. data on line 10 should line up wi. | New Users to Excel | |||
Hybrid Mode
