specialk802
New Member
- Joined
- Dec 27, 2015
- Messages
- 13
I am currently trying to use an OFFSET formula to declare a range for use in a Drop Down List. The formula works fine in a cell or range of cells however, when I try to use it in the Data Validation source it throws an error claiming something is wrong in the formula. After some investigation I found that it is considering the output from the match in the formula to be of the wrong data type despite showing a 2 and the data type when tested separately in a cell also resulted in a number. Any help to resolve this issue would be appreciated. The formula is below;
=OFFSET(Library!E2,MATCH(Reference!E4,ComponentLibrary[Connector],0),0,,7)
The error I receive when checking the formula;
Error In Value: A value used in the formula is of the wrong data type.
It then shows the formula reaching the error in the last step of the evaluation as;
=OFFSET(E2,2,0,,7) Note the 2 is in Italics
Not sure why it is evaluating it as a different data type. Any suggestions?
=OFFSET(Library!E2,MATCH(Reference!E4,ComponentLibrary[Connector],0),0,,7)
The error I receive when checking the formula;
Error In Value: A value used in the formula is of the wrong data type.
It then shows the formula reaching the error in the last step of the evaluation as;
=OFFSET(E2,2,0,,7) Note the 2 is in Italics
Not sure why it is evaluating it as a different data type. Any suggestions?