Hello from Steved

I have a file named Bus.xls
In it I have Values in Col A, B, C ,D

In a file Named Reports.xls I have information in Col A

ok in Col A in Bus.xls I have a value "B0101"
ok in Col A in Reports.xls I have a value "B0101"
What Formula would I use to lookup B0101 in Bus.xls to put
the information in Col B,C,D. of reports.xls Please.

Thankyou.