Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return data from a right hand side/and one cell down
I am compering the content of a cell agains another group of cells and when
it finds a match, I need the formula to return data from a specific cell on the right hand side and one or more cell daown from it. This is what I have so far but final yet. =IF(ISBLANK($C30),"",VLOOKUP($C30,Data!$A$1:$C$871 ,2,FALSE)) How can I do this. Thanks, -- When it commes to machinning, I am the BEST |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return data from a right hand side/and one cell down
What do you mean by "one or more cells down from it"? Is it one cell
down, or 2, 3 ?? You would be better using an INDEX/MATCH combination rather than VLOOKUP, but I can't give you a sample formula until you can define how many rows down from the matching cell you want the data returned from. Pete On Sep 16, 10:25*pm, JMALTO wrote: I am compering the content of a cell agains another group of cells and when it finds a match, I need the formula to return data from a specific cell on the right hand side and one or more cell daown from it. This is what I have so far but final yet. =IF(ISBLANK($C30),"",VLOOKUP($C30,Data!$A$1:$C$871 ,2,FALSE)) How can I do this. Thanks, -- When it commes to machinning, I am the BEST |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return data from a right hand side/and one cell down
'To return from 1 column to the right ColumnB and 2 row down
=IF(ISBLANK($C30),"",INDEX(Data!$B$1:$B$871,MATCH( $C30,Data!$A$1:$A$871,0)+2)) 'To return from 2 column to the right ColumnB and 1 row down =IF(ISBLANK($C30),"",=INDEX(Data!$C$1:$C$871,MATCH ($C30,Data!$A$1:$A$871,0)+1)) If this post helps click Yes --------------- Jacob Skaria "JMALTO" wrote: I am compering the content of a cell agains another group of cells and when it finds a match, I need the formula to return data from a specific cell on the right hand side and one or more cell daown from it. This is what I have so far but final yet. =IF(ISBLANK($C30),"",VLOOKUP($C30,Data!$A$1:$C$871 ,2,FALSE)) How can I do this. Thanks, -- When it commes to machinning, I am the BEST |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return data from a right hand side/and one cell down
I RECEIVED another example of someone else, suggesting to use the same
functions that you have suggested and it has worked. I saw your work with others in the forum and I think you could have lead me to a good result. Thanks, -- When it commes to machinning, I am the BEST "Pete_UK" wrote: What do you mean by "one or more cells down from it"? Is it one cell down, or 2, 3 ?? You would be better using an INDEX/MATCH combination rather than VLOOKUP, but I can't give you a sample formula until you can define how many rows down from the matching cell you want the data returned from. Pete On Sep 16, 10:25 pm, JMALTO wrote: I am compering the content of a cell agains another group of cells and when it finds a match, I need the formula to return data from a specific cell on the right hand side and one or more cell daown from it. This is what I have so far but final yet. =IF(ISBLANK($C30),"",VLOOKUP($C30,Data!$A$1:$C$871 ,2,FALSE)) How can I do this. Thanks, -- When it commes to machinning, I am the BEST |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return data from a right hand side/and one cell down
Thanks Jacob, I made some adjustment to your sugetions but in principal your suggestion works, -- When it commes to machinning, I am the BEST "Jacob Skaria" wrote: 'To return from 1 column to the right ColumnB and 2 row down =IF(ISBLANK($C30),"",INDEX(Data!$B$1:$B$871,MATCH( $C30,Data!$A$1:$A$871,0)+2)) 'To return from 2 column to the right ColumnB and 1 row down =IF(ISBLANK($C30),"",=INDEX(Data!$C$1:$C$871,MATCH ($C30,Data!$A$1:$A$871,0)+1)) If this post helps click Yes --------------- Jacob Skaria "JMALTO" wrote: I am compering the content of a cell agains another group of cells and when it finds a match, I need the formula to return data from a specific cell on the right hand side and one or more cell daown from it. This is what I have so far but final yet. =IF(ISBLANK($C30),"",VLOOKUP($C30,Data!$A$1:$C$871 ,2,FALSE)) How can I do this. Thanks, -- When it commes to machinning, I am the BEST |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the sum from the lower right hand side of the excel window | Excel Worksheet Functions | |||
Labeling The Right Hand Side Of A Graph With Axis Values ? | Charts and Charting in Excel | |||
y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel | |||
How do I get my y axis on the left hand side of my chart? | Charts and Charting in Excel |