How to HLookup but return a value in a different column.
 

Hlookup Searches for a value in the top row of a table of values, and then
returns a value in the same column from a row you specify in the table.
The data I need returned is always x number of rows down but the fourth
column to the right.

Appreciate if I could be pointed in the right direction regarding a formula
that would work for this requrement.

Let me know if I need to clarify further.

Cheers

How to HLookup but return a value in a different column.
 

Is your search data sequential and in ordered? If so, a basic LOOKUP
instead of HLOOKUP could accomplish what you want. In a LOOKUP, you
designate different ranges completely so as long as they are the same
size, they can offset as much as you want.

For instance:

=LOOKUP(C3,G1:J1,K5:N5)

The second range is offset by 4 columns and still works...as long as
the data in G1:J1 is ordered.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46897

How to HLookup but return a value in a different column.
 

.. data I need returned is always
x number of rows down but the fourth column to the right.

Another thought, maybe something like this:
=OFFSET(A1,x-1,3)
assuming the top left anchor cell is A1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"fats_71" wrote:
Hlookup Searches for a value in the top row of a table of values, and then
returns a value in the same column from a row you specify in the table.
The data I need returned is always x number of rows down but the fourth
column to the right.

Appreciate if I could be pointed in the right direction regarding a formula
that would work for this requrement.

Let me know if I need to clarify further.

Cheers