View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IP IP is offline
external usenet poster
 
Posts: 5
Default Multiple cell value

I am using a formula and it has 2 or 3 different cells, it like as follow:
cell A1: January, A2:CH
now I want to take a formula to use those two cells as a combine like,
Index($B4:$I9000,Match(cell("contents",$A$2),$B$4: $B$9000,0),2) --this is my
original formula now I want to change and put down a two matching cells like
A1 and A2 in the formula... How can I do this?