View Single Post
  #1   Report Post  
Brian Keanie
 
Posts: n/a
Default Lotus Equivalent

Would XL 2000 have an equivalent to the Lotus function "@XINDEX"?
@XINDEX returns a value at the intersection of row and column titles.

e.g. @XINDEX(Range,"Salary",A4) returns $200,050.00 (I wish)

The value in A4 = Brian.

To those of you who responded to my question on GROUPS ........ I got it!
Takes me a while 'cos I still think Lotus. Be patient. Best regards