# Lookup expression with more then one lookupcolumn

**URL:** <https://forum.inductiveautomation.com/t/lookup-expression-with-more-then-one-lookupcolumn/11043>\
**Category:** General Discussion\
**Created:** [January 14, 2016, 3:58pm UTC](https://forum.inductiveautomation.com/t/lookup-expression-with-more-then-one-lookupcolumn/11043 "2016-01-14T15:58:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Post date:** [January 14, 2016, 3:58pm UTC](https://forum.inductiveautomation.com/t/lookup-expression-with-more-then-one-lookupcolumn/11043/1 "2016-01-14T15:58:30Z")

</div>

Hi,  
is there an extension to the lookup expression command, so that I can look up more then one column, e.g. something like

```auto
lookup(dataset,lookupValue1,lookupColumn1,lookupValue2,lookupColumn2,.....,noMatchValue,columnValue)
```

Thanks in advance,  
regards

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 14, 2016, 5:30pm UTC](https://forum.inductiveautomation.com/t/lookup-expression-with-more-then-one-lookupcolumn/11043/2 "2016-01-14T17:30:00Z")

</div>

You can do this with the view() expression function in the [Simulation Aids](https://inductiveautomation.com/forum/viewtopic.php?f=50&t=14532) module, like so:`try(
  view("Select resultcolumn Where lookupColumn1==args[0] And lookupColumn2==args[1]",
    dataset,
    lookup1,
    lookup2)[0,0],
  noMatchValue)`