CODEWITHSUNDEEP
excel
Computer_Nerd
Computer_Nerd

Reputation: 102

Formula for Data Comparison

I am looking for a formula that will populate a cell based on yesterday's day value for last month.

Please see my example:


                          Prior Month Comparison |       |      |   
                                  5-Jul          | 5-Aug |4-Aug |    5-Jul
Total Number of Records:          10             |    25 |   7  |    10
Total Records Sold:               5              |    3  |   0  |... 5

I have all of July records to the right of my August records. I might have to use arrays so I'm not sure what would be the best approach.

I have looked into index/match but I'm not sure how to best apply this formula. I am available to any formula that will help me fill out my Prior Month Comparison column.

Thanks!!

Upvotes: 0

Views: 23

Answers (1)

Scott Craner
Scott Craner

Reputation: 152605

Use HLOOKUP:

=HLOOKUP($B$1,C:E,ROW(),FALSE)

enter image description here

Upvotes: 1

Related Questions