Vlookup with multiple columns

[bigband1]

Hello all,
As shown on the attached worksheet,I have a list of names in col C,and a longer list of names and related
data in cols BO,BR,BS & BT respectivly.I wish to use a vlookup formula to match the col BO data with cols
BR,BS & BT data the results being given in cols BJ,BK & BL as shown.Many thanks for any help given.

[benishiryo]

hi there. maybe this in BJ2?
=VLOOKUP($C2,$BO$2:$BT$656,MATCH(BJ$1,$BO$1:$BT$1,0),0)

copy down & across. for Column BK, some cells will return 0 if they are blank. you can either format cells as:
General;;

or use:
=VLOOKUP($C2,$BO$2:$BT$656,MATCH(BK$1,$BO$1:$BT$1,0),0)&""

[:) Sixthsense :)]

In BJ2 cell of Sheet1

=IFERROR(VLOOKUP($C2,$BO:$BT,COLUMN(D1),0),"")

Drag it down and right....

[bigband1]

Hi,The first formula when copied down &across just fills col BJ.The second formula also just fills col BJ but with the wrong data from col BS.I also need to fill cols BK & BL.It maybe because there are 2 empty cols between cols BO & BR.Thanks again.