Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
renwaters renwaters is offline
external usenet poster
 
Posts: 4
Default lookup

Good day

I want to be able to lookup in a col and row pull out an number:

18 19 20 21
1 25 26 27 28
2 18 19 20 21

So if match "1" for the col and match "19" for the row I want the function
to pull 26 out and place in the cell

I been working with this forumla:

=INDEX(Points!B$2:AC$46,MATCH("1",Points!B$3:B$46, 0),MATCH("19",Points!C$2:AC$2,0))

Thanks in advance

Renwaters