Thread: Vlook up 2 sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
  
Posts: 125
Default Vlook up 2 sheets
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1

Reply With QuoteReply With Quote