CODEWITHSUNDEEP
excelindexingvlookup
TylerNG
TylerNG

Reputation: 941

excel match index if exists

I have 2 excel sheets:

Sheet1: (Value = Prevalue)

Id   Preval Value    
111  1      1
123  2      2
100  3      3

Sheet2:

Id Num Date
111 5
123 6  1/1/18
100 7

I want to perform a logic saying that: Matching the 2 sheets by Id, if Date on sheet2 exists then Value on sheet1 = num on sheet2 else = Prevalue

Id Value
111  1    (same)
123  6    (update since date exists)
100  3    (same)

How would this be done using index or vlookup? Many thanks!

Upvotes: 0

Views: 652

Answers (1)

virtualdvid
virtualdvid

Reputation: 2411

Try this formula:

=IF(VLOOKUP(A2,Sheet2!$A$1:$C$4,3,0)="",B2,VLOOKUP(A2,Sheet2!$A$1:$C$4,2,0))

Upvotes: 1

Related Questions