vlookup (match on DA Number) to override the current incorrect data values

[Madhuri_G]

vlookup (match on DA Number) to override the current incorrect data values in accounts tab with the correct ones in Sheet1, namely G and H

I tried the formula but its not working. Please see attached.

 

[Hui]

Accounts!C2: =INDEX(Sheet1!$G:$G,MATCH(A2,Sheet1!$A:$A,0))
Accounts!D2: =INDEX(Sheet1!$H:$H,MATCH(A2,Sheet1!$A:$A,0))
copy both down

 

[Syedali]

vlookup (match on DA Number) to override the current incorrect data values in accounts tab with the correct ones in Sheet1, namely G and H

I tried the formula but its not working. Please see attached.

Hi,

VLOOKUP will work. I don't know why it is not. And one more information in your excel workbook calculation manual enabled change to automatic and try your formula.

 

[p45cal]

If you get a value like 42103, this is a date; you need to format those cells as dates.