"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!
|