Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function
Hi everybody, I have a problem with LOOKUP worksheet fucnction .. I used in a range of 10 cells .. in some of these cells it is returning a correct result .. but in other cells it is returning wrong result. the formuls I am using is the following: Code: -------------------- =LOOKUP("A2",Report!$F$2:$F$51,Report!$H$2:$H$51) Code: -------------------- I hope you can help me in this case, -- LoveCandle ------------------------------------------------------------------------ LoveCandle's Profile: http://www.excelforum.com/member.php...o&userid=28612 View this thread: http://www.excelforum.com/showthread...hreadid=566441 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |