Excel

[alliswell]

I have huge database with lots of columns and rows screenshot attached is for reference purpose

In A9 when i put any name from above database, i must get records from selected columns B,C,F

I tried with vlookup with column numbers in curly brackets but didnt work.

So please provide me with any good function with vlookup, index match, or choose offset which of these work smooth,

 

[Kaper]

try in B9 and copy right:

=INDEX($B$2:$F$6,MATCH($A9,$A$2:$A$6,0),MATCH(B$8,$B$1:$F$1,0))

PS. If you are using Excel in version 2007 (as stated in your profile) you may try to select 3 cells (B9:D9) and write in formula bar:

=INDEX($B$2:$F$6,MATCH($A9,$A$2:$A$6,0),{1,2,5})

and (that's important) commit this formula with Ctrl+Shift+Enter (not just Enter).

it can be not comma between 1 2 and 5 but other character. May be backslash \ ?
I am making this comment, because it could be different in Excel 2007.
I don't have access to 2007 since several years, but remember that there was some special case and change with Excel 2010 arrival. At least in Excel version with PL locale,

 

[alliswell]

try in B9 and copy right:

=INDEX($B$2:$F$6,MATCH($A9,$A$2:$A$6,0),MATCH(B$8,$B$1:$F$1,0))

PS. If you are using Excel in version 2007 (as stated in your profile) you may try to select 3 cells (B9:D9) and write in formula bar:

=INDEX($B$2:$F$6,MATCH($A9,$A$2:$A$6,0),{1,2,5})

and (that's important) commit this formula with Ctrl+Shift+Enter (not just Enter).

it can be not comma between 1 2 and 5 but other character. May be backslash \ ?
I am making this comment, because it could be different in Excel 2007.
I don't have access to 2007 since several years, but remember that there was some special case and change with Excel 2010 arrival. At least in Excel version with PL locale,

Thanks kaper. You are great