I need help on If, Mactch and Index function returning error

[bbcud]

I have a range of cells containing names in A6:A12. I also have corresponding values in columns B,C,D and E. I want to compare the value of C3 to see if it matches in the names then extract the corresponding values in B,C,D,E and placed them in column G,H,I, and J. This is the formula I used (=IF(MATCH($C$3 ,$A6:$A12,0),IN DEX($A6:$E12,1, 1,),"N/A")).and I get an error. Can someone help please. this is the sheet attached

[Rabbit]

You have an extra comma in your INDEX function at the end with nothing after it.

[hvsummer]

@bbcud: welcome to Bytes.com
actually, with your request, that code won't work.

I'll explain.
Match() return the number position of value from 1D Range,
Index() return value of (X,Y) in 2D Array/Range choosed.

to use index() + match() to lookup information
it should be like this

Index(FindRange example = "B6:E12", Row Number = Match( Value to find - $C$3 , 1D range - $A6:$A12, 0), Column Number = Column("B"))

if you want find wildcard, change "value to find" of match function to this

match("*" & $C$3 & "*", $A6:$A12, 0)