Vlookup across multiple sheets

I am trying to generate a list with the status of each room a maintenance project in a hospital. I want my formula to look at the cell to the left (contains the room number, user entry), search through 3 sheets, and return the status of the room. Each of the 3 sheets has the room # in the left column and its status in the right column, like this:

Capture.JPG

The formula I wrote works if the room# is in the first sheet, but returns "#N/A" if it is on the second, third, or not found. Here is the formula:

Please Login or Register  to view this content.

What am I doing wrong?

There are different approaches to this
one is using ISNA

Formula:

Please Login or Register  to view this content.

or

put the names of your sheet tabs say in Column K
K1- Sheet 1
K2 - Sheet 2
K3 - Sheet 3
then

Formula:

Please Login or Register  to view this content.

hope that helps.

regards,
Vladimir