View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
glasspumpkin glasspumpkin is offline
external usenet poster
 
Posts: 3
Default Find a value Using a lookup table multiple columns and rows

Thank you for your response I am looking for the formula for the lookup table
A10:M25 so in one cell I can input E and another 6 and the output cell shows
the connecting intersection of these cells , I tried this
"=HLOOKUP($P$8,$A$10:$M$25,VLOOKUP($P$9,$A$10:$M$2 5,2,FALSE),FALSE) and
didn't work just got more confused cells P8 and P9 being the input cells
horizontally and vertically

"Gary''s Student" wrote:

=E6
--
Gary''s Student - gsnu200794


"glasspumpkin" wrote:

I have a created table with a to k horizontally and 1 to 10 vertically , how
do i write the text to find where i input for example e ,6 and it comes back
the value at that point.