vlookup 2 cells at the same time

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,211
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
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?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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.
 
Upvote 0
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?
 
Upvote 0
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)
 
Upvote 0
=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 "".
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,211,710
Messages
6,103,451
Members
447,866
Latest member
bowers261

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
Back
Top