Thankyou Scott

"Scott Orchard" wrote:

Try putting this formula into cell B1 of reports.xls ...

=INDEX([bus.xls]SHEET!B:B,MATCH($A1,[bus.xls]SHEET!$A:$A,0))

For columns C & D, you can just copy the formula across.
You can then copy down as many rows as you need.
Rgds,
Scott

"Steved" wrote in message
...
| Hello from Steved
|
| My attempt is below is their a index and match I can use to do the same.
|
| =IF($A$1="","",VLOOKUP(A:A,BusType!A:D,2,0))
| =IF($A$1="","",VLOOKUP(A:A,BusType!A:D,3,0))
| =IF($A$1="","",VLOOKUP(A:A,BusType!A:D,4,0))
|
| "David McRitchie" wrote:
|
| Take a look at VLOOKUP Worksheet Function in HELP, and in
| http://www.mvps.org/dmcritchie/excel/vlookup.htm
| ---
| HTH,
| David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
| My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
| Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
|
| "Steved" wrote in message
...
| 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.
|
|
|