Try this:

=IF(ISNA(VLOOKUP(samir!A8,*S!$F$2:$G$10900,2,FALSE )),"",VLOOKUP(samir!
A8,*S!$F$2:$G$10900,2,FALSE))

Hope this helps.

Pete

On May 6, 9:40*pm, stan wrote:
Hello,

I'm trying to write a formula so that if excel can match a product in an
array it will go to another column to find the associated cost for the
product at a certain date. *I'm attempting to use the formula below but it is
not working. *Any suggestions would be helpful.

=IF(S!$A$2:$A$10900=samir!B$1,IF(S!$E$2:$E$10900=s amir!A8,VLOOKUP(samir!A8,*S!$F$2:$G$10900,2,FALSE) ,""),"")

Thank You,
Stan