Matching a Column in a table

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

Good day to you

I have a table of data (26 columns by15 rows), i need to match a 27th column of data to the table and the result must tell me the column number.

Any ideas on this...i have tried every variation of the "Match,Vlookup...and so on...

Please help!

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
try the array formula =SUM(($A$1:$E$5=$G1)*($A$6:$E$6)) after inserting the formula press CTRL+SHIFT+ENTER
Here $A$1:$E$5 - your data
$G1 - search item
$A$6:$E$6 - a new row contains column values