View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UKMAN UKMAN is offline
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.... :)