B
BNT1 via OfficeKB.com
Hi
Have used the following formula extracted from this site for some time
=IF(A2="","",IF(NOT(ISERROR(VLOOKUP(A2,UK!$A$2:$K$10000,4,FALSE))),VLOOKUP(A2,
UK!$A$2:$K$10000,4,FALSE),VLOOKUP(A2,Export!$A$2:$K$10000,4,FALSE)))
Works fine, except that there are duplicates on the sheets and often it
returns the one I didn't want.
Is it possible, someone can help to amend the formula, so that it returns the
greatest value in column 4 on the sheets UK and Export for the two entries
Example
LD123456 - 5700
LD123456 - 5740
Vlookup to return the greater value , ie, 5740.
Thanks in anticipation
Brian
Have used the following formula extracted from this site for some time
=IF(A2="","",IF(NOT(ISERROR(VLOOKUP(A2,UK!$A$2:$K$10000,4,FALSE))),VLOOKUP(A2,
UK!$A$2:$K$10000,4,FALSE),VLOOKUP(A2,Export!$A$2:$K$10000,4,FALSE)))
Works fine, except that there are duplicates on the sheets and often it
returns the one I didn't want.
Is it possible, someone can help to amend the formula, so that it returns the
greatest value in column 4 on the sheets UK and Export for the two entries
Example
LD123456 - 5700
LD123456 - 5740
Vlookup to return the greater value , ie, 5740.
Thanks in anticipation
Brian