Is Column C blank in the referenced cell? If so, that's the reason for
the #REF error, there has to be a value in that cell to avoid that
error, or you can add an IF/ISERROR function to your formula
Your lookup table is only one column wide, i.e. I190:I241, but your
third parameter is 2 meaning to return data from the second column.
Make your table wider.
Table array specified for single coulmn, but u r trying to retrieve
the data from column 2 which is not specified in table array.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.