# \[Solved\] Using VLookup in Airtable to display a picture
**URL:** https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499
**Category:** Questions about Thunkable X
**Tags:** solved, image, airtable
**Created:** [May 15, 2020, 5:11pm UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499 "2020-05-15T17:11:02Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [May 15, 2020, 5:11pm UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/1 "2020-05-15T17:11:02Z")
Hi,
I have an Airtable database with Exercise names and corresponding images.
Now when a particular exercise name comes up on screen, I want to display that image from the Airtable.
Theoretically, I am looping through the ExerciseName column and when a match happens, display that corresponding row in ExerciseGIF column.
However, I am not getting the picture on screen. Please help correct the blocks.
Susovan
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [May 15, 2020, 5:40pm UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/2 "2020-05-15T17:40:47Z")
See this post!
> [@Display images from airtable (10-min solve)](http://community.thunkable.com/t/display-images-from-airtable-10-min-solve/568568):
>
> I decided to tackle how to get images from airtable. [https://x.thunkable.com/copy/139eaa0b25b017f7e5d333f344dbe584](https://x.thunkable.com/copy/139eaa0b25b017f7e5d333f344dbe584) blocks used here are some notes! [\_remixThisProject](https://x.thunkable.com/copy/9cb95a696849675d7c5fff5b4207bf47)
---
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [May 16, 2020, 7:53am UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/3 "2020-05-16T07:53:27Z")
Hi Jared,
So I know how to get images from Airtable. If I specify the column and row, I am able to retrieve and display images. The following block is working since I know the exact row number.
However, my problem is about picking the image when the row number is dynamic. For example, when the name on screen is Squat, I should be able to retrieve the image of the Squat.
---
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [May 18, 2020, 4:01pm UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/4 "2020-05-18T16:01:24Z")
@Mark could you take a look at this? Any help will be appreciated.
Susovan
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [May 18, 2020, 6:09pm UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/5 "2020-05-18T18:09:08Z")
@thestrengthinstitute
Retrieve the column of exercises. Search through the returned list for the first occurrence of that exercise,
that is the row number
[http://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057?u=jared](http://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057)
first
save the active exercise to a variable named tempActiveExercise
then
call airtable and get column ExerciseName, save this to a variable named allExerciseNames. now allExerciseNames is a **list** of all the cells (or exercises) in the column ExerciseName.
next
in **list** allExerciseNames, find the first occurence of tempActiveExercise
save this result to a variable named tempRowNumber
use tempRowNumber in your Airtable call to retrieve the image.
get cell
in row (tempRowNumber)
in column (“ExerciseGIF”)
### then i reread the entire post so i made this
_[\_remixThisProject](https://x.thunkable.com/copy/9cb95a696849675d7c5fff5b4207bf47)_
---
### Author:  [@Mark](https://community.thunkable.com/u/Mark)
#### Post date: [May 18, 2020, 6:53pm UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/6 "2020-05-18T18:53:42Z")
> However, I am not getting the picture on screen. Please help correct the blocks.
Susovan,
I think the problem might be that you are specifying the `rowNum` as a text string (i.e. `"i"`). It needs to be the variable named ‘i’ instead. Do do that you should pull the variable block from the “Variables” drawer on left side of the Blocks Editor and use that instead. It will look something like:
Hope this helps.
-Mark
---
### Author:  [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)
#### Post date: [May 22, 2020, 4:27am UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/7 "2020-05-22T04:27:25Z")
Amazing!!! That worked.
Thanks @jared
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:29am UTC](https://community.thunkable.com/t/solved-using-vlookup-in-airtable-to-display-a-picture/568499/8 "2024-11-08T11:29:05Z")