| 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 |
| 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 | |||
Threaded Mode
