# a problem of matching

#### geologist1

##### New Member
Okay, here is the problem:

I need rain data for a list of specific dates from xx/xx/xx to xx/xx/xx.

In one column I have consecutive running dates with corresponding daily rainfall.

In another column I have the list of specific dates.

What is a quick way to match the daily rainfall to the specific dates in my list?

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Assuming that dates are in column A, rainfall numbers are in B and your search date is in C1:

=VLOOKUP(C1,A:B,2,0)

Not working. Sorry I am just learning VLOOKUP.

The running list of dates are in column R. The rainfall data is in Column S. The list of dates I need data for are in Column V.

=VLOOKUP(V1,R:S,2,0) ???

NVM I got it. Thanks for the help

That should work, yes, assuming the first date is in V1.

V1 is the date you want to look up.
R:S is the range you want to find it in, where the date should appear in column R.
2 is the number you want returned (second column, as first column would be the date itself).
0 means that you want to find the date exactly.

One of the most common problems with all Lookups is that the source data and the value to look for are not exactly the same. A quick way to see if this is a problem that you are having is to pick a date that you KNOW is in the column and put that in V1. Assuming that the date in the column is R1, type in =V1=R1 and if you get TRUE, then the numbers are exact matches. If you get FALSE, there is a problem with the source data.

Hope that helps.

EDIT: Just saw you got it after posting this, so that's good.

Last edited:

Replies
5
Views
475
Replies
4
Views
300
Replies
9
Views
308
Replies
2
Views
269
Replies
6
Views
235

1,221,127
Messages
6,158,087
Members
451,464
Latest member
Holden3

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back