On worksheet 1, I have a list like the one below.
<tbody>
</tbody>
On worksheet 2, I have pasted pictures from a external source. The pictures are already named and ordered (but are increments of 2). So they correspond like below.
<tbody>
</tbody>
I cannot use any macros, is there anyway to use VLOOKUP or INDEX MATCH (or any other method) to somehow match and show pictures (for column C in worksheet 1) based on the pictures that are in worksheet 2?
A | B | C | |
1 | List Number | Address | Picture |
2 | 15 | 44 Main St | ??? |
3 | 16 | 39 Triangle Ave | ??? |
4 | 17 | 961 Yellow Pkwy | ??? |
<tbody>
</tbody>
On worksheet 2, I have pasted pictures from a external source. The pictures are already named and ordered (but are increments of 2). So they correspond like below.
List Number | Image Name |
1 | Picture 1 |
2 | Picture 3 |
3 | Picture 5 |
... | ... |
15 | Picture 29 |
16 | Picture 31 |
<tbody>
</tbody>
I cannot use any macros, is there anyway to use VLOOKUP or INDEX MATCH (or any other method) to somehow match and show pictures (for column C in worksheet 1) based on the pictures that are in worksheet 2?
Last edited: