Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell references change when entering new data [email protected] New Users to Excel 2 May 6th 05 07:48 PM
Absolute cell references and subsequent problems. Pank Mehta Excel Discussion (Misc queries) 2 April 19th 05 11:38 AM
finding all references to a cell Brett Excel Discussion (Misc queries) 1 March 7th 05 01:25 PM
Sheet Names and Cell References Reed Excel Worksheet Functions 1 January 19th 05 10:17 PM
Changing Cell References in Formulas Pat Excel Worksheet Functions 2 December 15th 04 05:29 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"