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.
Orkut login - Guide
How to delete whatsapp account without login - Guide
Gmail login another account - Guide
Hi5 login old account - Guide
You need the official whatsapp to use this account ✓ - WhatsApp Forum

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

Facebook says that my email doesn't match my facebook email

i can't enter to my account facebook

Yahoo account reactivation

someone hacked my fb account and changed my password

Couldn't find your Google account

Similar discussions

Subscribe To Our Newsletter!