Home > OS >  Replace VLookup Values with VLookup Images (Google Sheets)
Replace VLookup Values with VLookup Images (Google Sheets)

Time:07-09

Afternoon everyone! Before reading, I'd review the example sheet.

I'm struggling with a line of code, where it will allow me to replace the value in a cell that is found using VLookup with a picture.

Link to example sheet: enter image description here

then use:

=IFERROR(VLOOKUP(IFERROR(ROUND(
 VLOOKUP($E6, Sheet3!$B$16:AC, 10, 0), 2)), Images!A:B, 2, 1))

enter image description here

  • Related