Vlookup with 2 matches?

admiral_Tristan

Board Regular
Joined
Dec 18, 2002
Messages
127
Hello guys! I have a question regarding using vlookup with 2 matches. I want to return a value Z if Value X is in A1, and Value Y is in B1, I want to return the Z that is in C1. I understand how to do this with 1 condition, but is there a way to do it with 2?

any help would be rockin

thanks
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
admiral_Tristan said:
Hello guys! I have a question regarding using vlookup with 2 matches. I want to return a value Z if Value X is in A1, and Value Y is in B1, I want to return the Z that is in C1. I understand how to do this with 1 condition, but is there a way to do it with 2?

any help would be rockin

thanks

You can either concatenate data from two columns and use Vlookup or and Index/Match combination. Can you post some sample data and expected reults. Or search the board for multi key lookups.
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

This formula must be entered with Ctrl + Shift + Enter
Book1
ABCDEFG
1agm
2bhncio
3cio
4djp
5ekq
6flr
Sheet4
 

admiral_Tristan

Board Regular
Joined
Dec 18, 2002
Messages
127
Thanks so much for the formula fairwinds, however it seems to really tax the system when I use it. I actually have over 1500 of them now in this one sheet I'm using, and it takes almost 30mins to compile. Is there any faster way to do this? heres the breakdown of what I'm trying to do

A B C-Z
phonenumber midnight-12:30 various data
phonenumber 12:30-1am

I'm matching and returning half hourly data on different phone numbers, so you can see why there would be so many. Is there a better way to do this type of mass matching?

Thanks again for your help.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,795
Members
416,983
Latest member
LessThanAverageUser

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