Isolating Data...

Hello,

I am really stuck with this one. I have a spreadsheet with 2 sheets
(Railcar Record & Switch) They both contain the same column names and will contain the same data.

What I want to do, is to have the user type in the Railcar # on Switch, and have all the information in the columns on this sheet fill in.

As you can see and as previously mentioned, the information is all stored on the Rail Car Record, I just need to isolate certain information on the switch sheet.

I hope I am being clear, any help is appreciated.

In A3:

=INDEX('Railcar Record'!$A:$A,MATCH($B3,'Railcar Record'!$B:$B,0))

in C3:

=VLOOKUP($B3,'Railcar Record'!$B:$P,COLUMN(B$1),0) copied across the remainder of the columns