Ask Your Question

Function Help please [closed]

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

Edd gravatar image

updated 2020-07-11 00:24:00 +0200

Alex Kemp gravatar image

image description

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 flag offensive 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

2 Answers

Sort by » oldest newest most voted

answered 2015-01-20 20:10:31 +0200

razon_22 gravatar image

updated 2015-01-20 20:25:17 +0200

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.

edit flag offensive delete link more

answered 2015-01-20 21:56:52 +0200

Edd gravatar image

updated 2015-01-20 22:30:07 +0200

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 image description

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

image description

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

edit flag offensive delete link 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.

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

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

Edd gravatar imageEdd ( 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.

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

it worked, thank you very much

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

Question Tools

1 follower


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

Seen: 90 times

Last updated: Jan 20 '15