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.