V LOOKUP with 2 lookup values???

[Daniellel]

Hi,

Can anyone tell me how to write a VLOOKUP formula that will match 2 lookup values?

I have a list of clients and a list of their jobs, I need to vlookup bits of info against a table.

Can anyone help?

Thank you.

 

[scottylad2]

Can you be a bit mnore specific? are you looking up clients names that will be listed in column 1 of a table as criteria 1 and what would be the lookup value of the second elenent? is it a column header?

 

[Daniellel]

Can you be a bit mnore specific? are you looking up clients names that will be listed in column 1 of a table as criteria 1 and what would be the lookup value of the second elenent? is it a column header?

Sorry,

I have a list (List 1) of clients in column 'A' and a list of their jobs in column 'B' I then all of their invoice details in columns 'C' to 'Y'. I have a seperate list (List 2) that just has the list of clients in column 'A' and a list of their jobs in column 'B'. I want to use VLOOKUP to return the data from list 1 into list 2 but it has to match BOTH column 'A' & 'B'.

Does this make sence?

 

[millhouse123]

Concatenate the two fields:
Column A(concatenated field) Column B Column C
FRANKJOE Frank Joe

The formula in cell A1 would be =B1&C1
Do this in both the data you are looking up from and the data you are lookinig up into. then use the new field to vlookup.

 

[Daniellel]

Concatenate the two fields:
Column A(concatenated field) Column B Column C
FRANKJOE Frank Joe

The formula in cell A1 would be =B1&C1
Do this in both the data you are looking up from and the data you are lookinig up into. then use the new field to vlookup.

Really sorry but i do not understand what you are telling me to do. I can not overtype columns 'A' & 'B' in either sheet, just need to add a formula to merge tham both together.

 

[Daniellel]

Maybe I am approaching this wrong, I might not even need to use VLOOKUP - maybe something else???

Can anyone help?

 

[scottylad2]

Excel Workbook
	D	E	F	G
12	Client 1	Painter	Value 1	Next Value 1
13	Client 1	cop	Value 10	Next Value 10
14
15	Client 1	Painter	Value 1	Next Value 1
16	Client 2	joiner	Value 2	Next Value 2
17	Client 3	plumber	Value 3	Next Value 3
18	Client 4	cop	Value 4	Next Value 4
19	Client 5	sailor	Value 5	Next Value 5
20	Client5	sailor	Value 6	Next Value 6
21	Client 1	joiner	Value 7	Next Value 7
22	Client 8	politician	Value 8	Next Value 8
23	Client 9	politician	Value 9	Next Value 9
24	Client 1	cop	Value 10	Next Value 10
Sheet1

THis will allow you to combine ywo criteria, your only difficulty will be selecting what columns you want to return the data from. You can either use an incrementer like i have (columns) to select columns next to each other or hard code the column numbers for the Inswx to reference