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!

We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history.
Gmail login another account - Guide
Orkut login gmail account - Guide
Hi5 login old account - Guide
Skype login history - Guide
How to delete whatsapp account without login - Guide

1 response

Answer 1 / 1

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

Similar discussions

Orkut forget login id and password

Getting email from Instagram a couple of years after deleting my account

Reactivating an old AOL account they deleted

Similar discussions

Subscribe To Our Newsletter!