Copy of value from one sheet to another with matching column values

[AA Arens]

I do have two sheets.

One sheet with a column of numbers X, and an empty column next to it.

Another sheet that also has a column with the same numbers Y, but not
as complete as the other sheet.
The next column has a value that belongs to the number in the previous
column.
How to copy that value in the empty column of the first sheet, with
matching values X and Y?

Thank you for your help.

Bart (Excel 2003)

 

[AA Arens]

I do have two sheets.

One sheet with a column of numbers X, and an empty column next to it.

Another sheet that also has a column with the same numbers Y, but not
as complete as the other sheet.
The next column has a value that belongs to the number in the previous
column.
How to copy that value in the empty column of the first sheet, with
matching values X and Y?

Thank you for your help.

Bart (Excel 2003)

Found it.

=VLOOKUP($F5,July!$A$4:$B$2000,2,FALSE) and to avoid empty cell error:
=IF(ISERROR(VLOOKUP($F5,July!$A$4:$B
$2000,2,FALSE)),"",VLOOKUP($F5,July!$A$4:$B$2000,2,FALSE))