LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Finding a cell and returning value from a different row and column

I have a term in cell F2. I'm trying to use that term to return a value from
a cell in a different row and column.

I have the INDEX/MATCH formula that will find the same term from column A
(A922). So I can get the cell(F2) to find the contents of the INDEX/MATCH.

Where I am stumped is trying to get the formula to lookup the term and then
return a certain value from a cell that is 4 rows down and 15 columns right
(Cell O926).

I know I can make a formula to find the exact contents of that cell. That's
not what I need. What I need is a generic formula so that I can change the
contents of cell F2, the formula will find the contents in column A, and then
lookup the value 4 rows down and 15 columns right. It has a certain piece of
information I need.
 
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
Finding specific text in one cell and returning data from another Klee Excel Worksheet Functions 8 April 2nd 09 08:49 PM
Returning same value cell in a column but different row. [email protected] Excel Worksheet Functions 4 May 31st 07 12:29 PM
finding the cell with min value and returning the contents of neig Will Excel Worksheet Functions 1 May 17th 07 10:18 PM
Finding text in a cell and returning a value based on that text [email protected] Excel Discussion (Misc queries) 5 January 10th 07 06:01 PM
finding cell value in another column and returning a true or fals bajanswing Excel Worksheet Functions 2 November 17th 06 08:33 PM


All times are GMT +1. The time now is 06:41 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"