vlookup 2 cells at the same time

[hsandeep]

I am using vlookup to get the values from another workbook.
Is it possible:
i use 2 Lookup_value & fetch the matching values.
In workbook1: I want to Lookup_value A1 with another workbook2 AND ALSO Lookup_value B! with workbook2 & then fetch a vaue lying in the 20 column (Colm_index_num).

How to accomplish it?

 

[Robert Mika]

Coudl you provide a beeter example?
To post data:
You can download and install two of the following programs:

HTLMaker

or
Excel Jeanie


or when using Internet Explorer just put borders around your data in Excel and copy those cells into your post.

 

[hsandeep]

Workbook1:

A1=PA1000 & C1=TASK1

Workbook2:
A1=PA1000 & C1=TASK1 F1=999

I am able to vlookup 999. ok

Workbook1:

A1=PA1000 & C1=TASK1

Workbook2:
A1=PA1000 & C1=TASK2 F1=999

I should not get 999 instead a null "" should appear.

Am I clear this time Or I can still give you more example.
Pls ask yr queries?

 

[Robert Mika]

Could you post your formula?
I you are getting result you may need to change 1 instead of 0 in the 4 criteria of your formula(the range_lookup)

 

[hsandeep]

=VLOOKUP(A1,Workbook2!A1:F999,6,0)

I am unable to put another VLOOKUP in this formula to check whether C1 (of Workbook1) MATCHES with C1 (of Workbook2)
& also unable to put IF condition over the formula to get a null "".

 

[andrewkard]

Hello, maybe this can help:

=IF(C1=[Book1.xlsx]Sheet1!C1,1,0)

 

[Robert Mika]

Maybe like this
=IFERROR(VLOOKUP(A1,Workbook2!A1:F999,6,0),"") (Excel 07/10)
=IF(ISERROR(VLOOKUP(A1,Workbook2!A1:F999,6,0)),"",VLOOKUP(A1,Workbook2!A1:F999,6,0)) Excel 03

 

[hsandeep]

I am using Excel 2007. So
=IFERROR(VLOOKUP(A1,Workbook2!A1:F999,6,0),"") should work. But what about MATCHING C1 also in the same formula?

 

[taurean]

There are two ways to do this:

1. Create a helper column and then combine column A and column B together on both sheets:
e.g. =A1&B1 which will make the data look like PA1000TASK1.
Now perform VLOOKUP on this combined data.

2. A single formula can be employed as well.

 

[hsandeep]

TAUREAN,

Please give formula for point#2.