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

Might want to use a different function

Example
A B C
Cat 1 Tan
Dog 2 Black

=VLOOKUP(A2,A1:C2,2,FALSE) - provides the answer 2

=VLOOKUP(A1,A1:C2,3,FALSE) - provides the answerTan


--Wag more, bark less


"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

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