On Jan 21, 1:58*pm, "T. Valko" wrote:
So what result are you looking for? The actual row number?

--
Biff
Microsoft Excel MVP

"Search & You Will Find" wrote in ...



Hello all.... I need to return the row where two statements are
true....

I have two columns, both with data. Column a is the "Role", column B
is the Application....

I need to to an index and match or something like that.... here's the
issue... both columns can have multiple entries that are the same.

Role
Admin Asst
Manager
Desktop Admin
Admin Asst
Manager
Desktop Admin
etc.

Application
Office 2007
Office 2007
Office 2007
Internet Explorer
Internet Explorer
Internet Explorer

I want to know the row where say Manager & Internet Explorer are the
same.

so no vlookup

so categorize column a, find all the rows that = true, then do the
same for b, and return the single row that has both as true.- Hide quoted text -

- Show quoted text -

On a separate sheet I have a column of Roles in column A (beginning at
A2) and a row of Applications beginning at B1. Where the two
intersect, I want to put an "X".