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

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