| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statements
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If, Then Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| IF Statements | Excel Discussion (Misc queries) | |||
| If statements | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Threaded Mode
