| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP return the value from the previous row
Im using the LOOKUP functions a couple of times in a workbook and it works
correctly in all places except one. Here's an example of what is happening: A B 1 Jane 20 2 Jack 30 3 Stan 40 4 Dave 50 =LOOKUP(Stan, A:A, B:B) In most places in my spreadsheet the result would be 40. BUT... in one particular place the result is 30. Can someone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cursor to previous position | Excel Discussion (Misc queries) | |||
| return previous date from list | Excel Worksheet Functions | |||
| Return Path to previous cell | Excel Discussion (Misc queries) | |||
| Return to a previous cell | Excel Discussion (Misc queries) | |||
| How do I return to a previous worksheet in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
