Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formula unexpected results
Hi Folks hope someone can help. One of you guys usually can. So thanks in
advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})),0,LOOKUP('Ho tel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})) spreadsheet developed in 2007 but others who access use 2003 office When COOK, D1 etc are entered it works great The following are also entered into the spreadsheet AL returns 0 correct ADO returns 0 correct LSL returns 5 should be 0 S returns 5 should be 0 PH returns 5 should be 0 C returns 0 correct C4 returns 0 correct M returns 5 should be 0 F returns 3.5 should be 0 for some reason the error checking in the formula seems to be ?? incorrect. hope someone can help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formula unexpected results
The number of items within the lookup vector and result vector should be same..
-- If this post helps click Yes --------------- Jacob Skaria "David Ryan" wrote: Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})),0,LOOKUP('Ho tel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})) spreadsheet developed in 2007 but others who access use 2003 office When COOK, D1 etc are entered it works great The following are also entered into the spreadsheet AL returns 0 correct ADO returns 0 correct LSL returns 5 should be 0 S returns 5 should be 0 PH returns 5 should be 0 C returns 0 correct C4 returns 0 correct M returns 5 should be 0 F returns 3.5 should be 0 for some reason the error checking in the formula seems to be ?? incorrect. hope someone can help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formula unexpected results
Hi jacob they are unless I am missing something
"Jacob Skaria" wrote: The number of items within the lookup vector and result vector should be same.. -- If this post helps click Yes --------------- Jacob Skaria "David Ryan" wrote: Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})),0,LOOKUP('Ho tel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})) spreadsheet developed in 2007 but others who access use 2003 office When COOK, D1 etc are entered it works great The following are also entered into the spreadsheet AL returns 0 correct ADO returns 0 correct LSL returns 5 should be 0 S returns 5 should be 0 PH returns 5 should be 0 C returns 0 correct C4 returns 0 correct M returns 5 should be 0 F returns 3.5 should be 0 for some reason the error checking in the formula seems to be ?? incorrect. hope someone can help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formula unexpected results
=IF(ISERROR(MATCH('Hotel
Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},0)),"",LOOKUP('Hotel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})) Would suggest you to use VLOOKUP with the details entered to a range. If this post helps click Yes --------------- Jacob Skaria "David Ryan" wrote: Hi jacob they are unless I am missing something "Jacob Skaria" wrote: The number of items within the lookup vector and result vector should be same.. -- If this post helps click Yes --------------- Jacob Skaria "David Ryan" wrote: Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})),0,LOOKUP('Ho tel Services'!AD91,{"COOK","D1","D2","D3","D4","D5","K 1","K2"},{10,8,8,8,5.15,3.5,8,5})) spreadsheet developed in 2007 but others who access use 2003 office When COOK, D1 etc are entered it works great The following are also entered into the spreadsheet AL returns 0 correct ADO returns 0 correct LSL returns 5 should be 0 S returns 5 should be 0 PH returns 5 should be 0 C returns 0 correct C4 returns 0 correct M returns 5 should be 0 F returns 3.5 should be 0 for some reason the error checking in the formula seems to be ?? incorrect. hope someone can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
UNexpected NPER results | Excel Discussion (Misc queries) | |||
Help please... Simple calculation - with unexpected results | Excel Worksheet Functions | |||
The ispmt function is providing unexpected results | Excel Worksheet Functions | |||
Equation giving unexpected results | Charts and Charting in Excel |