INDEX calling data that is drop down format?

Megan J

Hello,

I am having difficulty using INDEX. I would like to use it to call a data point into a new sheet, but the data it is calling has been input in a dropdown format. The formula works for data that is text, but gives INVALID VALUE when the data being called is from dropdown. Is there anyway around this? If at all possible I'd like to avoid inserting a new data column to convert from dropdown to text.

Thank you,

Megan

Paul Newcome

Can you provide the exact formula that you are using along with more details about your setup and workflow to include data types such as text vs numbers?

Megan J

=INDEX({Subject Tracker Range 1}, MATCH([Patient ID]139, {Subject Tracker Range 2}, 0), 22)

This formula works for column 22, which is a text column. I need it to call column 35, which is also text but the text is input from a dropdown menu not manually.

When I change to: =INDEX({Subject Tracker Range 1}, MATCH([Patient ID]139, {Subject Tracker Range 2}, 0), 35) the return is INVALID VALUE.

I would like it to return as text.

Thanks!

Paul Newcome

@Megan J Is that error present in any rows within the range? I have no issues pulling from a dropdown column into a text/number column. Also double check that the column number is in fact correct.