=if(A2='Y:\Backlog\[Backlog Category Rankings.xls]Backlog
Detail'!$E$6:$E$1000,VLOOKUP(A3,'Y:\Backlog\[Backlog Category
Rankings.xls]Backlog Detail'!$E$6:$Z$404,8),"")

Peter

"Stephen" wrote:

Please, please, please, post your formula!

"Looping through" wrote in
message ...
I need to compare a cell in a workbook against a range of cell in a
different
book. Sheet1 A2 against sheet 2 E6:E1000, If a match is found I want to
vlookup a cell in Sheet2, if not found return 0.

When I try to wite this formula, I get an error. My Vlookup work by
itself,
so I think it has to do with my IF statement.

Any suggestions
Thanks
Peter