View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Return the contents of a cell at the intersection of row and colum

I have a table in a sheet called "Pay_Table" in which there are grades in
column A and steps in row 1.

I need to do a lookup in another sheet that finds and returns the
intersection of a particular grade and step. For example, Lookup Grade 8 and
Step 5 and return the contents of that cell.

What formula can I use to do that?

Thanks much in advance...