Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP/HLOOKUP to Return Several Results | Excel Worksheet Functions | |||
Can you use HLOOKUP inside VLOOKUP to tell it what column 2 return | Excel Worksheet Functions | |||
Hlookup, how di I get it to return more than one cell | Excel Worksheet Functions | |||
Alternative to Vlookup/Hlookup to return a value. | Excel Worksheet Functions | |||
Hlookup to return a sum of values | Excel Worksheet Functions |