# Function Help please [closed]

Hi, how can I make the O4 (error:509) cell to show the month that corresponds with the number in the cell bellow 855. As you cand see 855 Ron belongs to month Decembrie ( December). So how can I make it recognize that the 855 represents month December ? Can someone please help me with this function ?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-08-15 00:25:24.688071

Sort by » oldest newest most voted

Use HLOOKUP in O4. The Value will be the cell below that finds the MAX value. That cell should be 855 RON to match the MAX value found. Also, copy the row with month names to row 16 so the VLOOKUP can find the Month name below the MAX value. Your range for the VLOOKUP will be rows 15 and 16. You can hide row 16 if you don't want it to be visable.

more

Ok, good. I get what you're trying to say, it makes sense, but i don't understand the way the hlookup works, i've tried some tutorials on youtube, but i can't get it right this is what I came to

and if i apply this it shows me: 900 instead of Decembrie, what am I doing wrong ?

i thought of that and modified after, but now it won't show me anything ...

more

The last part of your formula should be 2,1 instead of 1,1. You want to lookup the second row. As it is you are looking up row 1 of the range, which returns the value 900.

( 2015-01-20 22:10:00 +0200 )edit

ty tried that, but now it won't show anything

( 2015-01-20 22:31:12 +0200 )edit

unmerge the cells for the bottom two rows, delete the empty ones, and set the formula to the correct row.

( 2015-01-20 22:36:25 +0200 )edit

it worked, thank you very much

( 2015-01-20 22:40:26 +0200 )edit

## Stats

Asked: 2015-01-20 18:36:44 +0200

Seen: 90 times

Last updated: Jan 20 '15