get values from other cell from other sheet if match value match with other cell

2
votes

I have data on my sheet. Now I want to get data from my sheet1 to sheet2 if sheet1 Column A value match with sheet2 column A I want to copy Column B in sheet 2. 

Sheet one

Column A |             | Column B
=================================
Hello    |             | 1
World!   |             | 2
Foo      |             | 3
Bar      |             | 4

What I have now 

Sheet two

    Column A |             | Column B
    =================================
    Hello    |             |  
    World!   |             |  
    Bar      |             |

What I want 

 Sheet two

    Column A |             | Column B
    =================================
    Hello    |             | 1
    World!   |             | 2
    Bar      |             | 4
1
google-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

1 Answers

1
votes

use this:

=ARRAYFORMULA(IFNA(VLOOKUP(A:A; Sheet1!A:B; 2; 0)))