Array - matching data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have an array of columns "skills" and rows "names" with "level" as
intersecting data.

I can extract data by using index and match if I know 2 of the variables BUT
if I only know 1 variable i.e. skill what do I do... :(

To clarify, I have a skill and want to find and display the name and level
of those who have the skill.

Can anyone help please.... :)
 
Here's a small sample file:

delete2.xls 14kb

http://cjoint.com/?jdxRNVWILb

See if that's what you had in mind.

The formula to extract the names is an array formula**.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 
Hi,

If I could get you a knighthood I would. You are brilliant is all I can say.

many thanks.
Colin
 
Biff,

Your going to hate me But I have another match problem. (I am trying to get
an intermediate excel course so thanks for patience and help)
I have created an example but cannot find how to attach it.
In essence I have a register that records course / attendee details by row.
The column headings are such as Register ID, name, dept, team, course, cost
etc.

My task is to create 3 searchs to display the data on a sheet where I have
designed a suitable format for each:
1) Show consultants and various details by Dept (Has a drop down list to
select Dept)
2) Show consultants and various details by team (Has a drop down list to
select team)
3) for a given name show certain details i.e. course, cost, course register
ID, status
p.s. there are 3 levels of status, Approved, Reserved or All (Has a drop
down list to select status and name).

I've tried to amend your formula including setting "named" ranges but to no
avail.

Thanks as I am on a very tight deadline.

I don't know what I can do for you but please ask :)

Colin
 
If the file is <1mb in size and you want to send a copy to me I'll take a
look. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

No guarantees!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

producing a report via a keyword - filtering and macros not suitab 1
formula to return value from a matrix - I know hor and vert values 14
Help with using functions.... 1
Multiple Row and Column Criteria 8
Multiple Criteria across multiple Columns 2
getpivotdata custom subtotal cell reference 3
getpivotdata custom subtotal 5
Pivot Tables with text 3

Back
Top