|
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 |
lookup formula unexpected results
The easy way is to set up a lookup table and use VLOOKUP()
"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 |
| All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com