How many lookup values can vlookup use?

[chriswrcg]

I need to lookup some information based on two lookup values to pull data and populate certain cells in my workbook. The two values are name and date. here is an example: cell A1 - date, Cell A2 - Name, Cell A3 - data. If A1 is true and A2 is true then display data A3 in cell B1. Normally I would use vlookup and pull the data but I can't make it lookup both at the same time. Can vlookup do this or is there another way to find the data?
I have attached an example. If the date is 8/28/2017, and the name is Herman Awuku, then display B3. If the date is 8/31/2017, and the name is herman Awuku, then display f6.

[oeldere]

it depends on how your vlookup table is built up.



You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[tim201110]

=lookup(date,daterange/(namerange=name),valrange)

[chriswrcg]

I attached a file to work with.