View Single Post
  #1   Report Post  
Mr. Jan Park
 
Posts: n/a
Default How to lookup row # based on content of another column's cell

I have a 3 column table with 20 rows. The first two columns contain travel
expense data. The cells in the third column are blank exept for whichever
cell I enter an "x" in. Please let me what formula or worksheet function do
I use to calculate the travel expenses based on the data in the first two
columns that correspond to the row of the cell with an "x" in the third
column?

Thank You!