Excel copy data from another sheet based on criteria

0
votes

I have 2 Excel sheets and I want to copy data from sheet2 to sheet1 when the data in sheet1 is the same as in Sheet2

I tried Vlookup and INDEX-MATCH and i couldn't get them to work

Sheet1

Sheet1

Sheet2

Sheet2

I want to copy the Nr from Sheet2"B" to Nr in Sheet1"C" When the ID in sheet1 is the same as in sheet2.

Thanks in advance

1
excelindexingmatch
What about Vlookup? – Foxfire And Burns And Burns
i tried to use Vlookup and INDEX-MATCH they didnt work and i'm not that good with Excel – M.Aldein

1 Answers

1
votes

My data in Sheet2 is:

enter image description here

And in Sheet2 I got:

enter image description here

The formula I've used in Sheet1 in Cell C2 (and then drag down) is:

=VLOOKUP(A2;Sheet2!$A$2:$B$5;2;FALSE)