How to recognise a date within a range and then return the cell that is directly beside the result?

raetae

New Member
Joined
Jan 10, 2014
Messages
1
Hello, I am having some difficulty in using my VLOOKUP FUNCTION.

I have a a 2 column table, column A being a set of dates and column B has names of institutions. I want to have a formula that search for a date that is in a particular quarter and then return the name of the institution that would be in the corresponding column to the right. example may be found below

29-Sep-13

<tbody>
</tbody>
Scotia Jamaica Building Society

<tbody>
</tbody>
29-Sep-13

<tbody>
</tbody>
Bank of Nova Scotia Ja Ltd.

<tbody>
</tbody>
19-Nov-13

<tbody>
</tbody>
RBC Royal Bank

<tbody>
</tbody>
2-Dec-13

<tbody>
</tbody>
Portmore Community Development Fund

<tbody>
</tbody>
3-Dec-13

<tbody>
</tbody>
Palisadoes Co-op Credit Union Ltd.

<tbody>
</tbody>
12-Dec-13

<tbody>
</tbody>
Sagicor Bank

<tbody>
</tbody>
19-Dec-13

<tbody>
</tbody>
Kris an Charles Investments Co. Ltd.

<tbody>
</tbody>
10-Jan-14

<tbody>
</tbody>
Micro Investment Development Agency (MIDA)

<tbody>
</tbody>

<tbody>
</tbody>

Therefore if i were to have a list populated with the institutions that signed a contract between January 2014 and March 31, 2014. then that list should have one entity "Micro Investment Development Agency (MIDA).

If the formula is set to look for date between September 2013 and December 31, 2013, then all other entities would populate the list.


In lay mans terms, i need to a formula that will create a list of institutions out of column 2 above, IF the dates in column 1 fall in a particular range. I tried using a vlookup function like this:

VLOOKUP( A:A>=1/1/2014 <= 31/03/2014, A1:B6, 2, FALSE)
The problems is that the first argument "lookup value" seems to have to be an actual figure or cell. What i want is that the lookup value be determined through another formula and then that value is used to search the original table and return the value of the cell to the right.

e.g the lookup value should be determined by searching the column 1 for dates between a particular specified range and then return the values of the cells to the right of the lookups. Therefore the formula should be able to determine that 10 January 2013 falls between the specified range then return the value in column 2 (Micro Investment Development Agency (MIDA))


I know there is a way of doing this, can anyone help.


Thanks in advance
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,127,618
Messages
5,625,888
Members
416,141
Latest member
Bartek9q

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top