if statement with vlookup question? help me!!!!

[kaleb0521]

I have two worksheets both with similar IDs but different data. I am
using this formula
'=IF(J1376=VLOOKUP(A1376,NOV,7,0),VLOOKUP(A1376,NOV,17,0),"NO GOOD")'.
The IDs are in the worksheets twice but the second time it has
different data. If some one could help I will send a snipit of the
cells. I bascially need the VLOOKUP to not stop when it hit the first
TRUE.

 

[Harlan Grove]

I have two worksheets both with similar IDs but different data. I am
using this formula
'=IF(J1376=VLOOKUP(A1376,NOV,7,0),VLOOKUP(A1376,NOV,17,0),"NO GOOD")'.
The IDs are in the worksheets twice but the second time it has
different data. If some one could help I will send a snipit of the
cells. I bascially need the VLOOKUP to not stop when it hit the first
TRUE.

If the J1376=VLOOKUP(A1376,NOV,7,0) test applies to the first/topmost matching
ID (A1376) in table NOV, does it also apply to subsequent matches? For example,
if the first match for A1376 were in the 23rd row of NOV, and the 7th column on
that row equalled J1376, then the result should be the 17th column on that row.
If the next match for A1376 were in the 52nd row of NOV, would the 7th column on
that row also have to equal J1376? If so, and if multiple results would be in
sequential columns in row 1376 starting in column X, try this array formula in
cell X1376.

=IF(SUM((INDEX(NOV,0,1)=$A1376)*(INDEX(NOV,0,7)=$J1376))>
COLUMN()-COLUMN($X1376),
INDEX(NOV,SMALL(IF(INDEX(NOV,0,1)&CHAR(127)&INDEX(NOV,0,7)=
$A1376&CHAR(127)&$J1376,ROW(NOV)-CELL("Row",NOV)+1),
COLUMN()-COLUMN($X1376)+1),17),"no good")

Select X1376 and fill right as far as needed.