I am trying to integrate a vlookup command with a bmp. I have a bmp located
on my c: drive and I want to show this in cell B1. Ideally I want to copy
this formula down several cells as well. Am I close to getting the formula
below to work?

=IF(VLOOKUP(C4, PicTable, 2, FALSE)="State",activesheet.picture.insert
("C:\Documents and Settings\a-brjohn\State.bmp"),"")