I am trying to do Excel VLookup but the “Lookup Data” input box not letting me put in the column configuration I need, i.e. “A:B”. Instead, it just a dropdown with variables already defined. Per documentation, it should be a free-form text box? How do get around the issue? Just simple file with 2 columns. CSV attached here for reference.
Thanks.
type_model_xref.csv (191 Bytes)
Hello Adrian,
Thanks for reporting this. We are currently planning an update to the Excel VLookup action and its configuration fields.
During our review, we also noticed an important behavior difference: the standard Excel VLOOKUP function returns the first matching record, while the current Autom Mate action returns the last matching record. As part of the update, we plan to add an option that allows users to choose which matching value should be returned.
Until these improvements are completed, could you share a little more detail about your use case and the result you are trying to achieve? We can then check whether the same outcome can be handled with another action or approach in the meantime.
I figured out the workaround and in my use case, matching will always be unique.
