On Dec 20, 11:20*am, AA Arens <bartvandon...@gmail.com> wrote:
> 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))
|
