View Single Post
  #3   Report Post  
Jamie Furlong
 
Posts: n/a
Default

"Gary Brown" m wrote in
message ...
Move the list in column C over a couple of columns to, say, Column G
In Cell C1 (Assuming row 1 is the start of data), enter the following
formula...
=IF(ISNA(VLOOKUP(A1&".JPG",G:G,1,FALSE)),"",VLOOKU P(A1&".JPG",G:G,1,FALSE))
Copy this formula down your list.


Thank you very much! You're a genius!