LOOKUP

[Harvey Waxman]

I can't believe I'm having so much trouble with this easy task.

sheet #1
Column A values
Column F (a lookup formula)

sheet #2
Column A values
Column F values

If a cell in column A, Sheet #1 has a match somewhere in Sheet #2 column A, I'd
like the contents of the cell in Sheet #2 column F to appear in sheet #1 column
F in the appropriate row.

I have both A columns sorted ascending.

Thanks for any help

 

[JE McGimpsey]

I can't believe I'm having so much trouble with this easy task.

sheet #1
Column A values
Column F (a lookup formula)

sheet #2
Column A values
Column F values

If a cell in column A, Sheet #1 has a match somewhere in Sheet #2 column A,
I'd
like the contents of the cell in Sheet #2 column F to appear in sheet #1
column
F in the appropriate row.

I have both A columns sorted ascending.

One way:

Sheet1:

F1:
=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1,Sheet2!A:F,6,FALSE))

 

[Harvey Waxman]

One way:

Sheet1:

F1:
=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1,Sheet2!A:F,6,FALSE))

Thank you, as always.

There's progress but I got #N/A instead of the contents of the cell in column
F.

Here is the adaptation of your formula in row 19: =IF(ISNA(MATCH(A19,'sales
06'!A:A,FALSE)),"",VLOOKUP(A4,'sales 06'!A:F,6,FALSE))

Every cell in column F of 'sales 06' contains the word "new" so I tried this,
which give results I am looking for:

=IF(ISNA(MATCH(A19,'sales 06'!A:A,FALSE)),"","new")

I don't think I'll ever get the logic.

Could you parse it for me?

Please stay healthy.

Harvey

 

[JE McGimpsey]

One way:

Sheet1:

F1:
=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1,Sheet2!A:F,6,FALSE))

Thank you, as always.

There's progress but I got #N/A instead of the contents of the cell in
column
F.

Here is the adaptation of your formula in row 19: =IF(ISNA(MATCH(A19,'sales
06'!A:A,FALSE)),"",VLOOKUP(A4,'sales 06'!A:F,6,FALSE))

Every cell in column F of 'sales 06' contains the word "new" so I tried this,
which give results I am looking for:

=IF(ISNA(MATCH(A19,'sales 06'!A:A,FALSE)),"","new")

I don't think I'll ever get the logic.

Could you parse it for me?[/QUOTE]

I'm not sure why you used "A4" in your VLOOKUP rather than the "A19"
that's in your MATCH() formula. Unless they're the same value, that's
likely the source of your problem.

 

[Harvey Waxman]

Thank you, as always.

There's progress but I got #N/A instead of the contents of the cell in
column
F.

Here is the adaptation of your formula in row 19:
=IF(ISNA(MATCH(A19,'sales
06'!A:A,FALSE)),"",VLOOKUP(A4,'sales 06'!A:F,6,FALSE))

Every cell in column F of 'sales 06' contains the word "new" so I tried
this,
which give results I am looking for:

=IF(ISNA(MATCH(A19,'sales 06'!A:A,FALSE)),"","new")

I don't think I'll ever get the logic.

Could you parse it for me?

I'm not sure why you used "A4" in your VLOOKUP rather than the "A19"
that's in your MATCH() formula. Unless they're the same value, that's
likely the source of your problem.[/QUOTE]

The first row in one sheet is not the same number as the second sheet.

I recreated a tiny data set and your solution works perfectly. I don't know
what I did that was wrong before.

Many thanks once again