Multiple vlookup search criteria

[Rickster7]

I have two tabs and want to return a value in the first tab.

First tab - column A (Lname),B (Fname) and C (visit date) need to match to the second tab for the value.

On the second tab - column A (Lname, B (Fname) and F (Visit date) where K (charge amt) is the value i need returned to the first tab
in column L


Any ideas or suggestions would be most appreciated.

Thank you in advance!

 

[gaz_chops]

Try this entered as an array

=index(2ndtab!$K$1:$K$100,match(A1&B1,2ndTab!$A$1:$A$100&2ndTab!$B$1:$B$100,0))

If you need the date included then

=index(2ndtab!$K$1:$K$100,match(A1&B1&C1,2ndTab!$A$1:$A$100&2ndTab!$B$1:$B$100&2ndTab!$F$1:$F$100,0))

 

[Rickster7]

[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64, align: center"]=INDEX('Managed care as of 07102015'!$H$2:$H$2507,MATCH(A2&B2&C2,'Managed care as of 07102015'!$A$2:$A$2507&'Managed care as of 07102015'!$B$2:$B$2507&'Managed care as of 07102015'!$C$2:$C$2507,0))

THis is how i did it. I deleted columns in the second tab to the date can be the same column in the second tab but realized it doesnt make the difference. Im not getting the returned value from H
[/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]=INDEX('Managed care as of 07102015'!$H$2:$H$2507,MATCH(A2&B2&C2,'Managed care as of 07102015'!$A$2:$A$2507&'Managed care as of 07102015'!$B$2:$B$2507&'Managed care as of 07102015'!$C$2:$C$2507,0))

THis is how i did it. I deleted columns in the second tab to the date can be the same column in the second tab but realized it doesnt make the difference. Im not getting the returned value from H[/TD]
[/TR]
</tbody>[/TABLE]

You said "where K (charge amt) is the value i need returned to the first tab"?

However, did you enter as an array with Ctrl, Shift & Enter? If you did you would see curly brackets either end {}.

 

[Rickster7]

ok work perfectly. Just wasnt familiar with the Array function. thanks a million and happy monday

 

[gaz_chops]

You're welcome.