View Single Post
  #1  
Old May 30th, 2010, 02:44 PM posted to microsoft.public.excel.worksheet.functions
Dallasm
external usenet poster
 
Posts: 1
Default How to find a value with multi-column, multi-record list

I have a spreadsheet with $costs arranged according to values in both rows
and columns.
How do I create drop down lists for both the rows and columns and then
return the cell value?
eg if I have 5 rows (2-6) and 6 columns (B-G) with costs arranged in each
cell within this group how do I create drop downs for each selection, 2-6 and
B-G, and return the value to a selected cell.