- I have a table with two fields
- I wish to simply use one field to find the value in the other
- The source are line item values (Formatter step)
- The lookup appears to work however it returns the row number, not a field value from the table
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/1e29d488-0ee0-41ce-b11a-26d971e184d5.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/efd870b5-7d7a-4883-828f-0c911c8dfe4e.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4a9d6dd5-5a71-40e3-8a0b-6f060e342ffa.png)
Hi
Ah, it’s not actually returning a row number that’s the number for the blank line item it’s returned. Looking at the line item data it’s receiving (GST and GST Free) neither of those line item values contain the word gstData which is why it’s not finding a match:
And as no fallback value has been set it’s returning two empty line items. A lookup table will search the input to find a match for the keys (added on the left hand side) and return the value (that’s on the right hand side). For example if you wanted to output the value “InvoiceNinja” when a line item contains the word “GST” and output “A different value” when there’s a value of “GST Free” you’d set it up like so:
That would give you two line item values as shown below if the values GST and GST Free are passed into the lookup table:
That said, I see you’ve tagged Zapier Tables as one of the apps relating to this issue. But I’m not seeing any Zapier Tables actions in the screenshots of your Zap set up. So is it that you’re wanting to use the Formatter (Utilities > Lookup Table) action to search a Zapier table?
If so, you’ll want to try using a Find Record (Zapier Tables) action instead:
That action will allow the Zap to lookup a single row in the Zapier table and return all the information it contains.
Hope that helps to get you pointed in the right direction. If I’ve misunderstood or you run into any trouble on that do let us know! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.