Hi All,
I have a lookup table with two columns one like this:
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.
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.