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.

View 2 Replies

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.

View 6 Replies View Related

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]....

View 1 Replies View Related

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

View 14 Replies View Related

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?

View 2 Replies View Related

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?

View 5 Replies View Related

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.

View 9 Replies View Related

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?

View 4 Replies View Related

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.

View 9 Replies View Related

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?

View 3 Replies View Related

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.

View 2 Replies View Related

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?

View 3 Replies View Related

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

View 9 Replies View Related

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"

View 3 Replies View Related

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

View 4 Replies View Related

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

(instead of returning gibberish, will return a number instead)

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.

View 4 Replies View Related

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

View 7 Replies View Related

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:..............

View 3 Replies View Related

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?

View 5 Replies View Related

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))

View 7 Replies View Related

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].....

View 9 Replies View Related

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

Oct 15, 2013

View 4 Replies View Related

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

View 5 Replies View Related

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)

View 4 Replies View Related

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.

View 9 Replies View Related

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 Bread 2 0 1
18500 Cheese 3 8 4
71200 Eggs 9 6 3
71200 Bread 2 8 4
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.

View 9 Replies View Related

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.

View 3 Replies View Related

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:.............

View 7 Replies View Related

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.

View 2 Replies View Related

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:..............

View 2 Replies View Related