Defining the column of a named table to use with Match

**j_Southern** · 10-04-2013, 10:48 AM

I have a named table and I want to be able to specify which column to use when performing a Match to define the row I am interested in.
I can do this with an unnamed table by referring to the sheet column

ie MATCH(A1,SheetTable!$C:$C,0)

In my situation Col A has the matching variable Col B has the column identifier and NamedTable has the data in named columns and numbered rows

So I would like to write a formula such as

MATCH(A1, (NamedTable,B1),0) but of course I cant

How should I approach this?
I have attached a workbook with the table on sheet2 and the working on sheet1 to clarify my problem.
John

**XOR LX** · 10-04-2013, 11:13 AM

Hi,

Do you want to return the actual row number? Or the row number relative to your defined table (which begins in row 5)?

As an example, is the return for Colour 3331.00, Column B to be 21 or 17?

This formula in C11 will return the latter:

=MATCH(A11,INDEX(Sheet2_Table,,MOD(CODE(B11),63)),0)

Regards

Defining the column of a named table to use with Match

LinkBack

Thread Tools

Rate This Thread

Display

Defining the column of a named table to use with Match

Re: Defining the column of a named table to use with Match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Get distinct values from Named Range, Table Column, or Pivot Table Row Label/Column Label?

Defining a named range entirely within VBA

Using Named References and then Defining Them

[SOLVED] Defining a named range

Excel 2007 : Defining Named Ranges Based on a Values in Another Column

Bookmarks

Bookmarks

Posting Permissions