hlookp

Hi I need to horizontally look at a data set & return the date of the most recent sale. in this example, 2 sales occurred in April 2024, so cell A2 returns 4/30/2024. A3 returns 1/31/2024 b/c 3 sales most recently occurred in Jan 2024. A1 return Formula 06/30/2024 05/31/2024 04/30/2024...

Hello. In row 2 there are a time stamps and in row 3 I have a values for each of those stamps. Example. <tbody> A B C D E F G H 1 2 Time stamps 48 45 42 39 36 33 30 3 Values 2.63 2.53 2.48 2.44 2.60 2.67 2.69 </tbody> With a simple hlookup formula I could find...

This post is meant to be a reply to the old 2012 post that I just read. The site does not allow me to reply to the old post-Link below- https://www.mrexcel.com/forum/excel-questions/5404-what-xlookup.html I just want to revive this question because I am working on a project where XLookup...

I'm looking for help developing a formula that will return the results... 1st, 2nd, 3rd, 4th, etc 51st, etc. <tbody> Date Name Department TO Variance CC! CC2 CC3 5-24.99 25-49.99 50-199.99 200-399.99 400 or more YTD 02/27/15 Bill BAR Bar Manager (99.95) 6th $50.00-$199.99 9 3 6 0 0 18...

Hi folks, I hope you can help, I'm trying to run a PO/budget sheet with 4 currencies in it. I'd like to have a column at the end which calculates my monthly outgoings in GBP, using a fixed exchange rate. I'd like the function to see which column (B/C/D/E) has a figure in it, convert it to GBP...

Hi, I am trying to compile a calculator based on a set of options selected by the user. I want to use validation to allow a list of 3 choices which then determines what further options are available. This is the table. <TBODY> Area 1</SPAN> Area 2</SPAN> Area 3</SPAN> 0-2 & TS</SPAN> 3-4...

Hi, I am hopeing that this is an easy question for one of you. Allthough I have mastered vlookup's I dont know how to takle this particular problem. I am a product manager and am trying to make an anylisis workbook. On one sheet (Promotions Forecast) I have each appropriate month listed in the...