Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup row 5
i need a formula to lookup a value in row 5 and return the value in row 1.
As far as i have discovered it can only lookup row 1 and return a result for cells below. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup row 5
Clinton;431024 Wrote: i need a formula to lookup a value in row 5 and return the value in row 1. As far as i have discovered it can only lookup row 1 and return a result for cells below. Any help would be appreciated. You can use an INDEX/MATCH construction, e.g. if lookup value is in B3 =INDEX(1:1,MATCH(B3,5:5,0)) -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119704 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HLookUp | Excel Worksheet Functions | |||
hlookup | Excel Discussion (Misc queries) | |||
HLOOKUP and SUM | Excel Discussion (Misc queries) | |||
hlookup #N/A | Excel Worksheet Functions | |||
HLOOKUP | Excel Worksheet Functions |