View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathryn Kathryn is offline
external usenet poster
 
Posts: 8
Default Lookup on two criteria


Dear all

I would like to create a lookup or index that finds a particular entry by
column and row. This is my data

part number month1 month2 month3 month4
123 10 20 30 40
456 50 60 70 80


On another sheet I have two selection cells, I have selected part number 123
and month 2, in another cell I want to see the result 20.

I hope this makes sense.

I really appreciate any help as I am relatively new to excel

Kathryn