# Equivalent of VLOOKUP in Knack?
**URL:** https://forums.knack.com/t/equivalent-of-vlookup-in-knack/7445
**Category:** Get Answers
**Created:** [February 5, 2017, 5:39pm UTC](https://forums.knack.com/t/equivalent-of-vlookup-in-knack/7445 "2017-02-05T17:39:00Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@AndyBlair70520](https://forums.knack.com/u/AndyBlair70520)
#### Post date: [February 5, 2017, 5:39pm UTC](https://forums.knack.com/t/equivalent-of-vlookup-in-knack/7445/1 "2017-02-05T17:39:00Z")
Hi,
What's the equivalent of a VLOOKUP in Knack?
I have a table of numbers that correspond to names, e.g.
Area Number Area Name
1 Simpson
2 Ross
When creating records, it is easiest to use the number, but on one of my pages, I want to have a column of the numbers and then another column that looks up and returns the name that corresponds to the number. In Excel or Google Sheets, this is easily done with VLOOKUP. Does anyone know how to do this in Knack?
Thanks for your help,
Jim
---
### Author:  [@ZiadQ](https://forums.knack.com/u/ZiadQ)
#### Post date: [June 6, 2018, 8:53am UTC](https://forums.knack.com/t/equivalent-of-vlookup-in-knack/7445/2 "2018-06-06T08:53:43Z")
Hi Jim,
I recently asked a similar question involving "vlookup" and Nic was kind enough to give us a solution:
[https://support.knack.com/hc/en-us/community/posts/360010413412-How-can-I-do-a-VLOOKUP-in-knack-?page=1#community\_comment\_360001189372](https://support.knack.com/hc/en-us/community/posts/360010413412-How-can-I-do-a-VLOOKUP-in-knack-?page=1#community_comment_360001189372)
Hope this helps.
Cheers,
Ziad