LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 70
Default Array - matching data

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.... :)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching identical data using data only once in the matching proce Robert 1 Excel Discussion (Misc queries) 1 June 29th 07 04:22 PM
return values from an array based on matching text value WFBJoeB Excel Worksheet Functions 10 May 14th 07 07:57 PM
Matching Values from an Array Mal Excel Worksheet Functions 2 January 4th 06 10:06 AM
Matching data and linking it to the matching cell yvonne a via OfficeKB.com Links and Linking in Excel 0 July 13th 05 07:30 PM
Matching an Array in one Tab with an Array with another Tab LanceMSU Excel Worksheet Functions 4 February 22nd 05 02:16 AM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"