View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Positive Positive is offline
external usenet poster
 
Posts: 37
Default HLOOKUP and choose one value among 2 values

Hi,

I have a spread sheet that formats assumingly for HLOOKUP. However,
under the name of the property which takes up 2 cells, there are 2
values. For example, under Property RIVER , there are rent values for
March and April. I only want to update one value. What formula should
I use.

Property RIVER FOREST MOUNTAIN
Month
Rent 30 40 35 45 65 70