Zapier Platform: Lookup between sheets

[ryanb4614]

I am trying to figure out something with Zapier. Basically I will be pulling an email address from a database with zapier. Zapier allows you to apply a formula to a cell. I need to see if the email is listed in another sheet. The issue is I need the formula to be row specific. Example: I would normally use Vlookup with the designated cell "B4" and copy it down the column. But in zapier i needs a specific formula because it only applies the formula in the net empty row. So I need it to call the row number it is in instead of B4 if that makes sense?

[MrShorty]

I know nothing about Zapier, so I don't know how much I can help with that. I think I understand your formula question. If I understand what you are saying, the solution might be similar to the VBA solution -- use R1C1 notation to write the formula. In VBA programming, the advantage to using R1C1 notation is that the formula text for a copied formula will not change. =VLOOKUP(RC2,lookup_table,2,0) will always refer to column B of the current row no matter what row (or column) the formula is entered into. If your Zapier programming language has the ability to write R1C1 formulas to Excel, that might be a workable solution.

[ryanb4614]

Thank you! That sounds like it is exactly what I am looking for. Just zero experience with it. If you can help me out it would be greatly appreciated. Formula will be placed in Column E. Column B has a header "Emails" and the list of emails will appear here. I need to see if the email listed in Column B of that row the formula is applied to exist in another sheet called "Customers". On sheet "Customers" the email column is J.

[MrShorty]

I'm not sure what you need help with. As noted, I cannot help with whatever programming language Zapier is using.

If your question is mostly about how to use R1C1 references, then this should be a useful read https://support.office.com/en-us/art...3-c311f47ca173 (see the "R1C1 reference style" under "using references in Excel formulas"). If you have a nice a named reference for you lookup table, then something like I showed in my previous post should be the formula =VLOOKUP(RC2,named_reference,2,FALSE) (assuming the desired return value is in the 2nd column of the lookup table).

What part of writing this formula into the spreadsheet do you need help with?

[ryanb4614]

That you for the explanation. I was able to solve it.