Antrosenthal
New Member
- Joined
- Mar 15, 2011
- Messages
- 2
I am trying to run a HLOOKUP function however can not get it to work.
I am trying to identify a specific date which returns the smallest number in a range of numbers. I would like the HLOOKUP to identify a specific date where a business makes the biggest loss. So if I new that the biggest losses that the company made were say 100,000 I would like to know which month this event occurred in.
1. In cell C30 I have run a MIN calculation to determine what the smallest number is over a range of numbers =MIN(Data!I32:DX32) (Data is the page that I am picking the numbers off)
2. I would then like to determine the date that the MIN number is in, so what I did was in the row above the string of numbers, I ran the dates which were monthly dates increasing by one month at a time. So the HLOOKUP I ran was
=HLOOKUP(C30,Data!I31:DX32,1,FALSE), where C30 represents the number from 1, row 31 are the dates and row 32 are the numbers.
The result I keep getting is #N/A ................very frustrating
I am trying to identify a specific date which returns the smallest number in a range of numbers. I would like the HLOOKUP to identify a specific date where a business makes the biggest loss. So if I new that the biggest losses that the company made were say 100,000 I would like to know which month this event occurred in.
1. In cell C30 I have run a MIN calculation to determine what the smallest number is over a range of numbers =MIN(Data!I32:DX32) (Data is the page that I am picking the numbers off)
2. I would then like to determine the date that the MIN number is in, so what I did was in the row above the string of numbers, I ran the dates which were monthly dates increasing by one month at a time. So the HLOOKUP I ran was
=HLOOKUP(C30,Data!I31:DX32,1,FALSE), where C30 represents the number from 1, row 31 are the dates and row 32 are the numbers.
The result I keep getting is #N/A ................very frustrating