LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default lookup and offset combination

Hello

I am trying to return the value of a cell that is offset from a lookup reference cell. My data looks something like this (if it shows ok)

A B C
1 name 50 65
2 100 3
3 40 2

Cells A2 and A3 are empty. If I always want to return the value 2 columns over and 2 rows down from the lookup "name" (which happens to be in cell A1, but may not always be in that cell), what formula combination do I use? I have tried nesting lookup in offset, but I get an error message. Here is how I wrote it

=offset(LOOKUP(e50,A1:A500,b1:b500),2,1)
e50 contains "name
The lookup returns the value in B1, and I was hoping by nesting it in offset I could get the value in C20 which is 2 rows down and 1 column over from B1

Any thoughst? Thanks.
 
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
Index, Match, Lookup, Vlookup or Combination? Tom Davis Excel Worksheet Functions 0 November 2nd 09 11:56 PM
If, Lookup, Match or a combination of all Beverly Darvill[_2_] Excel Worksheet Functions 3 July 22nd 08 11:26 AM
Lookup valid combination of multiple cells Gerard Excel Worksheet Functions 5 November 9th 07 10:32 AM
Lookup and offset Elliott Excel Discussion (Misc queries) 0 February 23rd 06 10:23 PM
Tricky Formel (counting days in combination with lookup) chrismania[_4_] Excel Programming 2 October 20th 03 02:59 PM


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