Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
Reverse HLOOKUP with a range
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 50%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Dany Wagner
0
Reputation points
Hi! Please help!
Any way to make a "reverse hlookup" function to get value from the 1st row knowing the date? (see the pic)
Thanks in advance!
Excel
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AllenXu-MSFT 24,941 Reputation points Moderator2023-06-05T06:40:42.2733333+00:00 @Dany Wagner ,
Welcome to Microsoft Q&A.
I cannot get you clearly as per the description. For help you better, could you please share an example here? What exactly the function of "reverse Hlookup" should be? From the screenshot below, you want to get the value from 1st row C1 "2-JUN-2023" to C14 using the function, right?
-
Dany Wagner 0 Reputation points
2023-06-05T08:06:12.25+00:00 @AllenXu-MSFT Hi! Thanks for your reply! Yes. Having a date I would like to know the shift. Is the date from column day, night or day-off.
So I believe it should be a Hlookup but it does not work down to up
Sign in to comment