# VLOOKUP Across Multiple Columns?

Aug 19, 2013

Basically, I have an array of data (let's say A2:D20). I then want to do a VLOOKUP across the columns A:D, and return the corresponding value in column G, if VLOOKUP can find a particular value from column F, say.

So, I need a VLOOKUP function written in G2, that finds the value E2 in EITHER A2,B2,C2 or D2 (and return what is in E2, say).

I first thought I could CONCATENATE the strings in A2, B2, C2 and D2 and use some sort of VLOOKUP that finds a string within another string.

## VLookup - Single Value Lookup Returning Multiple Records Into Multiple Columns

Feb 7, 2014

Certification and Training tracking.xlsx

I want to create a certification only list on a separate tab of training that has been completed where a certification has been issued (as indicated by a "Y" in the "Certification?" column on the training tracking tab) and then populate from some of the fields vs. all of the fields.

What I have now, only pulls the first occurence, not all occurences. I saw that I could have identified the multiple columns that needed to be populated, but it didn't work either, so I'm fine putting a separate vlookup in each column.

## VLOOKUP For Multiple Ranges In Multiple Columns

Feb 21, 2013

Im trying to make a vlookup so I can say find a record where column A is >4, B is =2, C is 1.

Example - The lookup would find these 2 ranges.

7
2
3

2
6
4

[code]....

## VLOOKUP On Multiple Columns?

Jun 10, 2014

I've used VLOOKUP based on matching one column and returning one result. No problem. Now I need to return one result based on 3 columns matching.

Assume this range of columns is named: TravelDays
Origin...Location...ShipVia...TravelDays
33778...420...UPS...3
33778...425...UPS...1
33778...440...UPS...3
33778...443...UPS...3
33778...446...UPS...2
33778...447...UPS...3
33778...449...UPS...5
33778...475...UPS...3

What I'm trying to accomplish is if these columns match:
i2=Lookup!TravelDays,1
E2=Lookup!TravelDays,2
N2=Lookup!TravelDays,3

My result should be: Lookup!TravelDays,4

## VLOOKUP Across Multiple Columns?

Dec 16, 2012

I have a list of names I need to look up against another list. My problem is that the second list has a mixed formatting of Firstname Lastname and Lastname Firstname. What I did so far is create a second column that reverses the first and last names in the column.

Table1:

A
B

1
Name
Name (reversed)

2
John Smith
Smith John

3
Jackson Laura
Laura Jackson

4
Maxwell Ted
Ted Maxwell

5
Chris Hansen
Hansen Chris

Table2:

A
B

1
Name
Currently employed?

2
John Smith
=IF(ISNA(VLOOKUP([A1; Table1!A:A;1;FALSE));"NO"; "YES")

3
Laura Jackson

4
Ted Maxwell

5
Chris Hansen

The VLOOKUP formula works great but I need it to look for a matching name across Table1:A:B not just Table1:A:A. How would I do this?

## How To Get VLOOKUP Over Multiple Columns

Jul 20, 2011

i am trying to get a VLOOKUP to work over a number of different columns. An example the problem:

Sheet1

A B

1 10
2 20
3 30
4 40
5 50

Sheet1 is the sheet i want to lookup the values and i want to place the results into column B

Sheet2

A B C
1 10 40 50
2 20
3 30

Sheet2 contains all the infromation that i want to look for to make the comparison.

I know that the expression used for the VLOOKUP is:

Code:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

The issue i have is "col_index_num" as i want to look over multipule columns. I have been using this expression:

Code:
=VLOOKUP(A2,Sheet2!\$A\$1:\$J\$20000,1,FALSE)

How do i change the "col_index_num" to look over all 3 columns and not just the 1st, 2nd, or 3rd?

## Vlookup To Return One Value From Multiple Columns?

Sep 21, 2013

I have two separate worksheets, and I am trying to create a Vlookup or Index and Match formula. Here is the example:

Sheet 1
Cell A1= Employee ID: 123-D.

Sheet2
Vlookup A1 from Sheet 1, and match the first five characters to Column A, Column I and Column P. If a match, return name (e.g. John Doe) in Sheet 1, cell B1.

## Vlookup From Multiple Columns With Only One Return

Dec 19, 2008

I have a spreadsheet with twenty columns. Column A has an item number (say "Clutch"), and the remainder of the columns have values. However, there only be one column in the range B:T which will have a value on the same row as "Clutch" (say "Black" in column "N").

How I can I return "Black" using a vlookup or should I be using something else?

## Vlookup Multiple Items Using Two Columns

Sep 14, 2009

I have two columns of data each with repeats. I want to be able to look up the third column of data and then list the multiple results attaching to the first two columns.

I have attached a dummy spreadsheet of what I am trying to achieve.

## VLOOKUP Selecting Multiple Columns?

Sep 11, 2012

i have the following table, i want my Vlookup not only get the description from Column K but to get column K , L , M City and Country as well and put them in Columns D for Description, E for City and F for Country. would this be possible with Vlookup formula or any other formula?

## Essentially VLookup Off Multiple Columns

Oct 27, 2013

creating an equation that could essentially vlookup off multiple columns.

I get a report once a week with a list of employee ID numbers. I have a separate spreadsheet with employee names, ID 1, ID 2, ID 3, ID 4, in columns A,B,C,D,E , respectively.

I am trying to put a forumla in the report where it will take the employee ID number and reference it to my separate spreadsheet and give me back a name if it matches any of the 4 IDs that pertain to that employee.

I've tried index/match but I believe match only looks at one column.

## Vlookup Search Of Multiple Columns

Feb 23, 2007

I have an XLS sheet filled with every zip code in the US... the zips are in multiple columns adjacent to columns with the corresponding county names.

Unfortunately, the there are up to EIGHTEEN columns of zip codes in each row describing the counties... not one zip per row. I'm assuming this was done to save space.

In another sheet, I have list of client zip codes and need to VLOOKUP the corresponding county from the first sheet. I'm certain I'm not using VLOOKUP right...I'm getting #N/A every time.

Is this because it's only checking the first column of zip codes? I need it to check all 18 columns of course... there are no repeated zips.

How do I do this without rebuilding the full zip database page?

## Vlookup Returning Multiple Values In Different Columns

Apr 18, 2014

I have attached a file with an example of what i am looking for. The data in columns A and B are my original Data. There are multiple instances of e-mail address on the left but I need to bring in each data horizontally. I would like a formula to enter into E2:J6 to pull the information in.

Book2.xlsx

## Vlookup And Concatenate Multiple Columns Of Date?

May 8, 2014

Say in L4 on form test i want to look for the value of A4 in Drill data range a2 to z1000 and retun a concatenated string of something like "sav 407 : 08-may to 11-may"

## Excel 2007 :: Vlookup Using Multiple Columns?

Jun 27, 2011

I'm looking to simply find a function that allows me to lookup a certain value in a table of data and return the value in a specific column. So if I looked up the current date, 6/27/2011, it would return the week it is in (26). I dont want to be limited to just the monday column however, as the dates I will be throughout the entire week. Is there an easy way to do this in excel 2007?

MondayTuesdayWednesday ThursdayFridaySaturdayWeek
5/2/20115/3/20115/4/20115/5/20115/6/20115/7/201118
5/9/20115/10/20115/11/20115/12/20115/13/20115/14/201119
5/16/20115/17/20115/18/20115/19/20115/20/20115/21/201120
5/23/20115/24/20115/25/20115/26/20115/27/20115/28/201121
5/30/20115/31/20116/1/20116/2/20116/3/20116/4/201122
6/6/20116/7/20116/8/20116/9/20116/10/20116/11/201123
6/13/20116/14/20116/15/20116/16/20116/17/20116/18/201124
6/20/20116/21/20116/22/20116/23/20116/24/20116/25/201125
6/27/20116/28/20116/29/20116/30/20117/1/20117/2/201126
7/4/20117/5/20117/6/20117/7/20117/8/20117/9/201127
7/11/20117/12/20117/13/20117/14/20117/15/20117/16/201128
7/18/20117/19/20117/20/20117/21/20117/22/20117/23/201129
7/25/20117/26/20117/27/20117/28/20117/29/20117/30/201130
8/1/20118/2/20118/3/20118/4/20118/5/20118/6/201131
8/8/20118/9/20118/10/20118/11/20118/12/20118/13/201132
8/15/20118/16/20118/17/20118/18/20118/19/20118/20/201133
8/22/20118/23/20118/24/20118/25/20118/26/20118/27/201134
8/29/20118/30/20118/31/20119/1/20119/2/20119/3/201135
9/5/20119/6/20119/7/20119/8/20119/9/20119/10/201136
9/12/20119/13/20119/14/20119/15/20119/16/20119/17/201137

## Looking Up Value In Table (multiple; Unique Id; Columns For No Vlookup)

Mar 30, 2009

What formula should I use so that it will find the match with a 6-column table (with every other column containing the 'reference' items, so I can't use vlookup)

So that it will return the value next to the match

Solved

Okay had that table setup that way because I needed separate tables ("linked" comboboxes")

So I just altered it so that the vlookup range changes dependent on the value of combobox 1.

## Excel 2007 :: VLookup Across Multiple Columns

Feb 20, 2012

I am using Windows xp and Excel 2007. I'm creating a user form and have a vlookup formula that goes to a table and looks up calories and sodium based on the text entered by the user. My problem is that I want to be able to populate the 3 columns with information and then sum the values that are returned to the Calories and Sodium columns. Is that possible with Vlookup?

=IF(ISNA(VLOOKUP(F8&G8&H8,Food!A:E,4,FALSE)),0,VLOOKUP(F8&G8&H8,Food!A:E,4,FALSE))

Water 24 ozOther DrinksGelsSolid FoodCaloriesSodium

00
00
00

## Multiple Ccolums/rows To Get Data From Multiple Columns/rows (vlookup)

Jan 15, 2010

I have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............

## Cascading Ranges - Vlookup (make My Reference Range Access Multiple Columns)

Feb 10, 2010

I need to run a vlookup to find some data. But I have a lot of data about 600,000 lines. Currently this list is spread over several columns (as the limit is something like 50000). How can I make my reference range access multiple columns?

## Create Multiple IF Statement And Multiple VLOOKUP Within Same Formula

Aug 11, 2014

I am trying to create a formula which looks in 1 cell to determine 'IF' it states either "BUTT CUT" or "DIE CUT" and then does a VLOOKUP in a table array for each which ever column relates to asnwer to 'IF statement.

This is as far as I have got but even this won't work:

=IF(I15="BUTT CUT",=VLOOKUP(J15,V13:Z22,2,FALSE))

## Excel 2007 :: Automatically Transfer Columns From One Worksheet To Another In Multiple Columns?

May 4, 2013

I would like to take the data from worksheet1 and put into worksheet2 but limit the length of a list (the real spread sheet has over 100 rows and i would like them in 4 sets of 25 versus the example I provided). Is there an array or macro that would make this work (keeping the formatting)..

Excel 2007
B
C
3
Name
Company

[Code].....

## How To Combine Multiple Columns Into Long List Of Results In 2 Final Columns

Oct 15, 2013

I have a need to combine multiple columns into a long list of results in 2 final columns. Here is my example...

Current layout with varying number of data points per row...

ColumnA | ColumnB | ColumnC | ColumnD | etc...
example1 | Test1 | Test2 | Test3 | Test4
example2 | Option1 | Option2
example3 | Number1 | Number2 | Number3 | Number4 | Number5

Desired Result

ColumnA | ColumnB
example1 | Test1
example1 | Test2
example1 | Test3
example1 | Test4
example2 | Option1
example2 | Option2
example3 | Number1
example3 | Number2

and so on and on and on until all rows have been filled in down the file...

Is this possible?

## VLookup In 2 Columns

Aug 20, 2014

I'm looking for a vlookup that will look in 2 columns of the array table and output an answer based on them.

See the attached example : Example.xlsx

## VLookup - How To Sum Two Different Columns

Jan 13, 2014

I have the following concern as i'm not able to solve it alone:

Ex: =vlookup(c11;flyingprogram;2+5;false)

## VLookup In Different Columns

Feb 21, 2013

Code:

A B C D
1 2801 2 2816 1
2 2802 2 2815 0
3 2803 3 2814 88
4 2804 4 2813 99
5 2805 5 2812 2
6 2806 6 2811 6
7 2807 4 2810 1
8 2808 3 2809 4

I'm new here and I saw that many people actually have excellent knowledge in excel.

Well, I'm trying to use vlookup on my sheet, but the data I have comes with the code and your score his side.

In a standard vlookup would be: = vlookup (value, range, 2, false).

This is the problem, I would like that when he could not find the value in column A or B, were to column C or D and so on.

## Vlookup Two Columns

Jul 3, 2009

I have a spreadsheet with the following data:

A B C D E
18500 Eggs 4 6 9
18500 Cheese 3 8 4
71200 Eggs 9 6 3
71200 Milk 1 0 8

I need a formula to check column A, then B and return a result from C:E.

Column A is 18500 or 71200
Column B is Eggs, Bread, Milk or Cheese
Column C, D E are sales figures.

## Multiple Columns Which Need To Be Combined With Some Columns Not Having All Cells Fill

Apr 30, 2014

I have a spreadsheet with 10 columns which are for tags for products. Some columns are filled in for 10 products and some are not. For instance, product 1 has 7 tags while product 2 has only 2 tags and so on. Now what I am looking to do is combine all the tags for each product with a "," inbetween each one. The problem is if I just use a simple =A2&","&B2&","&C2 etc formula is that if there are only 2 tags then I get 8 ","s. I also tried it with an IF statement but by the time I was done nesting items I became cross eyed and said there has to be an easier way to do this.

I have create a spreadsheet with the data and the result that I typed into the "result" column.

## Copy Multiple Columns Groups To 1 Group Of X Columns

Aug 6, 2009

Example:................

The key point is that I have over 400 columns grouped in three, offset by one row down for each (this is due to a different formula I have working). Each column is 60 numbers long (not including empty cells above data). I want to copy all of these columns into a single set of three columns on another sheet (Sheet2). (These will be the fifth, sixth, and seventh columns, E, F, and G. If it would be simpler, I could simply copy the third of each set of columns on Sheet1 (C, F, I) to column G of Sheet2. Then there would be a total of 144 columns being copied (60 numbers per column).) All of this copying has to be values-only as the original columns consist of formulas referencing outside cells. Sheet2 should look like this:.............

## Sort Multiple Columns, With Blanks, And Move All Columns Into One

Feb 15, 2010

I found this code on Ozgrid to sort all columns of a worksheet that were continuous with no gaps or spaces that works well:

Sub CopyToA()
Do While ActiveCell <> ""
Range(ActiveCell, ActiveCell.End(xlDown)).Cut Destination:=Range("a65535").End(xlUp).Offset(1, 0)
ActiveCell.Offset(0, 1).Select
Loop
End Sub

However, I've tried to manipulate the code myself to 1) find all columns that aren't empty then 2) sort each column individually (WITHOUT expanding the sort to other columns) and 3) combining all the numbers into one seperate column. There are many posts concerning sorting but not one that addressed this particular situation.

## Move Data From 2 Columns Into Multiple Columns At Each Change

Feb 2, 2008

I am trying to write a macro that will take data from column A and use it as a column header in column C, and then take the corresponding data in column B and list it under the column header in column C. When the value in column A changes it will move on to column D and then list the corresponding data from column B underneath it in column D until all of the data in the 2 columns is spread across the worksheet. Example:..............