Index one column off an area of match (but no headers)

[Parmx]

I'm stuck again lol,

I want to index one column that has values to the right of it, but not header values so that an index match match isn't possible. I've attached example

[kersplash]

What about this;

Please Login or Register  to view this content.

[Parmx]

But that's missing a column? it dosen't include column D?

[samba_ravi]

Match function works only for multiple rows with single column or multiple columns with single row, but it will not works with multiple rows and multiple columns

[kersplash]

What about this;

Please Login or Register  to view this content.

[Parmx]

Yeah that's what i ended up doing, but there could end up with 5 or 6 columns. The data was a sample. However that will do for now

[FlameRetired]

Try

Please Login or Register  to view this content.

or try array entering this. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

[Parmx]

Thanks Dave! perfect

[FlameRetired]

You're welcome. Thanks for the feedback.