excelqueen
New Member
- Joined
- May 2, 2002
- Messages
- 18
I am using LOOKUP function to autofill cells, based on the selection of other cells in the same row.
The problem is that if nothing is selected in the corresponding cells it shows #NA in the autofill (where i am using the LOOKUP function) cells
Is there a solution to this problem? Thanks in advance for your help!
The problem is that if nothing is selected in the corresponding cells it shows #NA in the autofill (where i am using the LOOKUP function) cells
Is there a solution to this problem? Thanks in advance for your help!