Looking for a formula to find the postion of a value anywhere in an array

PLeeY3

New Member
Joined
Sep 4, 2014
Messages
2
Hello,

I'm looking for an array to find the placement of a value, in this case a word, that doesn't appear in the same column or row. Basically I'm running from a clients server and they're not all the same so the row and/or the column varies between various clients.

I also don't need the cell location per se, I can just add one to the column index to get the value I need.

Currently I'm pulling the data in sheet 2 and then on sheet 3 I use and a match formula in columns A-F and rows 1-6. This finds the location but is starting to get messy and I was hoping to condense the various rows/columns into a single cell.

I'm looking for CPU cores:

Client A has this value on row 7 column 9
Client B has this value on row 34 column 10

Please let me know if there is any confusion over the request.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Is this the sort of thing you want?


Excel 2010
ABCDEFG
1Col1Col2Col3Col4GHILMN
2Row1ABCFGHKLMPQR
3Row2BCDGHILMNQRS
4Row3CDEHIJMNORST
5Row4DEFIJKNOPSTU
6Row5EFGJKLOPQTUV
Sheet1
Cell Formulas
RangeFormula
G1=INDEX(B2:E6,MAX(INDEX((B2:E6=F1)*(ROW(B2:E6)-ROW(B2)+1),)),MAX(INDEX((B2:E6=F1)*(COLUMN(B2:E6)-COLUMN(B2)+1),))+1)
 
Upvote 0

Forum statistics

Threads
1,224,271
Messages
6,177,608
Members
452,785
Latest member
3110vba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top