View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Array - matching data

Is "level" a number?

--
Biff
Microsoft Excel MVP


"UKMAN" wrote in message
...
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.... :)