Hi @sd2024 

Help articles for using Excel in Zaps: https://zapier.com/apps/excel/help

• There can be no completely blank rows before the end of your spreadsheet.

@Troy Tessalone 

Thanks for getting back to me. The entire row is not blank, and rows contain data in other columns. I did not include the data in the screenshot as it is sensitive data.

Do you mean it can’t have blank data in that column for the lookup?

@sd2024 

In general, I advise users to use other apps such as Airtable or GSheets in stead of Excel.

Things to check/try:

Reselect each dropdown field value.

Check the Lookup Value has no leading/trailing whitespace.

Unfortunately, I can’t change to a better platform. But I do agree that other platforms are better.

@Troy Tessalone I made the changes now and added data into the column where it was blank, and it didn’t change the outcome and still has the issue/error.

I also re-selected each dropdown field value, as per your suggestion.

@sd2024

Try testing with other Lookup Values to see if you still encounter the error.

If you are going to use using a static lookup value, then do you even need the Excel step?

Perhaps just add the other column data to the following Zap step fields.

 @Troy Tessalone I get that “ID” from Trello in a previous step. In the live case, there is “no data”, so I have to rely on the test output in order to map data to steps thereafter.

I tried with other values and for each it gave the same error message.

@sd2024 

Try this…

Map the dynamic variable for the Lookup Value field.

Turn the Zap ON.

Test live.

Check your Zap Runs history to see the DATA IN/OUT for each step: https://zapier.com/app/history/

 
@Troy Tessalone

 
Data In : 
 

storage_source : one_drive

folder_id : 01B6JRWY2ROG6XTWUHZZBZBSCR6QS3GJCU

_zap_search_success_on_miss : False

workbook_id : 01B6JRWY3N6DVL4PDEFBD3HAQIBVQHHBDX

worksheet_id : {0198D1C8-8809-7D48-9CD1-EE919ADF20B6}

lookup_key : COL$A

lookup_value : 65fe7a915fc7fc23c7c90c4d

Data Out : Nothing

Same error as before, Live. I also recreated the step, but that also did not change anything.

@sd2024 

You can try opening a ticket with Zapier Support: https://zapier.com/app/get-help

@Troy Tessalone I think I figured it out. The issue was the file I was working on on Zapier and the file that I am looking at on Excel is different. Their names were very similar, but they are not the same.

I created a Table in the file I have in Excel, and it didn’t show up on Zapier. 

Thank you very much for your help and assistance.

That’s an awesome news @sd2024! We’re glad to hear that the issue is now resolved.

Also, a huge thanks to Troy for lending a hand here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!