Vlookup with 2 matches?

[admiral_Tristan]

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

 

[Brian from Maui]

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]

Hi,

This formula must be entered with Ctrl + Shift + Enter

Book1
	A	B	C	D	E	F	G
1	a	g	m
2	b	h	n		c	i	o
3	c	i	o
4	d	j	p
5	e	k	q
6	f	l	r
Sheet4

 

[admiral_Tristan]

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.

 

[fairwinds]

Hi,

you can do like in this post

http://www.mrexcel.com/board2/viewtopic.php?t=73864&highlight=char+127

concatenate the columns with a special character inbetween