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..

=IF('Qualtrics Output'!AJ3="","",LOOKUP('Qualtrics Output'!AJ3,{1},{"Caucasian"}))

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

In that case simply..

=IF('Qualtrics Output'!AJ3="","","Caucasian")