1 or blank cell pulls exact text or leaves cell blank

I am asking a person's race and they have the option to select many. The output is given as such:

Pt Race_1 Caucasian	Pt Race_2_African American	Pt Race_3_Asian or Pacific Islander	Pt Race_4_Other_Text
1	1		Person's text response

So, if it is answered there is a 1 but if not the cell is blank. Can I code for a blank cell in the lookup function below? (I know it's not correct, I don't know how to do it).
=LOOKUP('Qualtrics Output'!AJ3,{1,blank},{"Caucasian","blank"})

Each cell is going to have to have its own function but they should all be similar (minus the Other Text option).


For the Other Text cell I need to be able to pull the exact text answered but also have the ability to have a blank cell if there is nothing in said cell (it currently gives me a zero). ='Qualtrics Output'!AK3

try this...
=LOOKUP('Qualtrics Output'!AJ3,{1,""},{"Caucasian",""})

edit: if you have a bunch of selections, it may be better to put them in a separate table, and use a vlookup() to return what you need

Please Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Why not..

Please Login or Register  to view this content.

you can then add lookups for 2,3,4, etc too within the curly brackets

In that case simply..

Please Login or Register  to view this content.