If with Vlookup
Right, well A2 cannot equal 'Y:\Backlog\[Backlog Category
Rankings.xls]Backlog Detail'!$E$6:$E$1000.
A2 is a single value, the other is an array of 995 values!
You need a MATCH function to see if A2 appears in the array (this returns
the position in the array, or #N/A), and then ISNUMBER to decode what it
returns:
=IF(ISNUMBER(MATCH(A2,'Y:\Backlog\[Backlog Category Rankings.xls]Backlog
Detail'!$E$6:$E$1000,0)),VLOOKUP... etc.
"Looping through" wrote in
message ...
=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
|