Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the folowing formula in a spreadsheet in cell c1 (nested lookup
function) =VLOOKUP(ROUND(B4*100,3),INDIRECT(VLOOKUP(B2,produ ctlookup,2,0)),2) Lets say this brings back the results from cell x5 (or.25). If I want to bring back the next few rows (x6,x7and next few columns z5,z6,z7) in the rows and colums next to this response is there a way to do it ? I hope my question is clear - Im confused just writing it. Thanks, Yosef PS - One more silly question, when I post questions - I am often getting messages that my request cant be done and brought to a generic page. Any idea why ? Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell references change when entering new data | New Users to Excel | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
finding all references to a cell | Excel Discussion (Misc queries) | |||
Sheet Names and Cell References | Excel Worksheet Functions | |||
Changing Cell References in Formulas | Excel Worksheet Functions |