If Statements

[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

 

[Brad]

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

 

[Pete_UK]

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