S
stan
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=samir!A8,VLOOKUP(samir!A8,S!$F$2:$G$10900,2,FALSE),""),"")
Thank You,
Stan
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=samir!A8,VLOOKUP(samir!A8,S!$F$2:$G$10900,2,FALSE),""),"")
Thank You,
Stan