Need help in Checking cells in different files and showing results in the next cell

[topsoft]

Hi to all,

I'm new here and I need help on monitoring two files.
I'm trying to check 2 separate files. Looking if a cell (example A3 in file1) exist in Column A of file2. If so, than copy file2 B3 cell next to File 1 A3 that should be File1 B3.
If does't exist than show an error or ''Doesn't exist"
I'm attaching a file example...

Anticipated Thanks

[Leith Ross]

HEllo topsoft,

Place this formula in B3:B6. It will look up the value in A3:A6 in the other table and return either the status or nothing.

=IFERROR(VLOOKUP(A3,$G$3:$H$6,2,FALSE),"")

You should change the other table to a named ranged in the other workbook. You can then use that range name in the formula to make easier to read.

[topsoft]

Thank You very much Leith