Thread: Cell References
View Single Post
  #1   Report Post  
ynissel
 
Posts: n/a
Default Cell References

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.