Matching a Column in a table

Closed
PJ - Sep 7, 2009 at 01:57 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 7, 2009 at 11:25 AM
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

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 7, 2009 at 11:25 AM
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
0