I have a lookup table with two columns one like this:

Excel Workbook | ||||
---|---|---|---|---|

A | B | |||

1 | Yes | Yes | ||

2 | No | No | ||

3 | N_A | Not applicable | ||

Sheet1 |

And have a dropdown to give the user the option to choose one of the three in column B. I have created a lookup thus;

=IF(ISNA(Index etc),"",Index etc)) to lookup the appropriate value in column A when the value from column B is selected. I wondered if a simpler method would be to try to use boolean logic to avoid the error statement if the cell was blank? If I use (X1<>"")*(Index etc) it returns an error since I guess it is looking for a numerical value.

In addition, could boolean logic return the value for the lookup?

The data from column A is being used in another program and the excel sheet will be used to upload information into this database and needs to be useable in Excel 2003.