Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]() Did you follow all of the rules for LOOKUP? Is the data in 'EXCEL PRICE BUILDER'!$B$339:$B$347 sorted in ASCENDING order? If not, it is possible to return an incorrect value. from HELP: Important The values in lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent. Good Luck -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=374126 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing from Access issue | Excel Discussion (Misc queries) | |||
Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
New Excel Comment Box Issue | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |