# VLookup

### Vlookup

Rate this:
(3/5 from 1 vote)

Hello,

I needed help with the VLOOKUP..  here is what I'm trying to do...

If you look below.. then you will see that Column A has all the names and Column B has it's Value.. likewise.. Column D has all the names and Column C has it's values...

I'm trying to first match the names from Column A to Column D and if it matches then I want to see if Column B matches to Column C..

For examples, in Column A and B, it shows that AES Corporation has a B1 value and column C and D also shows that AES Corporation has a B1 value.. so it should come back with TRUE. If it had same names, but different values, it should come back as false..

 A B C D 1 AES Corporation B1 BI AES Corporation 2 Alliance Imaging B1 B1 AES Corporation 3 Altivity Packaging LLC B1 B1 Affinity Group Inc 4 AMR Holdco B1 B1 Air Evac EMS Inc 5 Aramark Corporation B1 B1 Air Evac EMS Inc 6 Bluegrass Container Canada Company B1 B1 Alliance Imaging 7 Bluegrass Mills Holdings Company LLC B1 B1 Alliance Imaging
Posted by on

 Replies - Displaying 1 to 4 of 4 Order Replies By: Most Recent | Chronological | Highest Rated
 Rate this: (2/5 from 3 votes) This is an interesting problem because a simple VLOOKUP or MATCH function will not suffice as their maybe more than one occurence of company names in columns A and D.The solution is to first concatenate columns A and B and also columns C and D.Enter the following formulae in the cells indicated then copy down.E1: =A1&B1F1: =D1&C1G1: =VLOOKUP(E1,\$F\$1:\$F\$7,1,FALSE)H1: =IF(G1<>"#N/A",TRUE,FALSE) Excel Business Forums Administrator Posted by Excel Helper on 29 Aug 2007
Rate this:
(3/5 from 1 vote)

I received "#N/A" all the way down.. did I do it right??

 AES Corporation B1 B1 AES Corporation AES CorporationB1 B1AES Corporation #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Alliance Imaging B1 B1 AES Corporation Alliance ImagingB1 B1AES Corporation #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Altivity Packaging LLC B1 B1 Affinity Group Inc Altivity Packaging LLCB1 B1Affinity Group Inc #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A AMR Holdco B1 B1 Air Evac EMS Inc AMR HoldcoB1 B1Air Evac EMS Inc #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Aramark Corporation B1 B1 Air Evac EMS Inc Aramark CorporationB1 B1Air Evac EMS Inc #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Bluegrass Container Canada Company B1 B1 Alliance Imaging Bluegrass Container Canada Company B1 B1Alliance Imaging #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Bluegrass Mills Holdings Company LLC B1 B1 Alliance Imaging Bluegrass Mills Holdings Company LLCB1 B1Alliance Imaging #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Bombardier Recreational Products Inc B1 B1 Alliance Imaging Bombardier Recreational Products IncB1 B1Alliance Imaging #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Builders FirstSource Inc B1 B1 Alliance Imaging Builders FirstSource IncB1 B1Alliance Imaging #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A CHS/Community Health Systems Inc B1 B1 Alliance Imaging CHS/Community Health Systems IncB1 B1Alliance Imaging #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A Colfax Corporation B1 B1 Alliance Imaging Colfax CorporationB1 B1Alliance Imaging #N/A "#N/A",TRUE,FALSE)' x:err="#N/A">#N/A

Posted by on
 Rate this: (3/5 from 1 vote) It looks like in cell F1 you put =C1&D1 instead of =D1&C1 - i.e. the company name followed by the value. Excel Business Forums Administrator Posted by Excel Helper on 31 Aug 2007
 Rate this: (3/5 from 1 vote) In my vlookup excel , the following types are not working properly... lookup_value table_array col_index_num range_lookup Can anyone suggest me how to implement these functions i vlookup ??? Any kind of reply would be greatly appreciated. [http://www.videoconferencingnow.com/] Posted by Sheridan on 26 Mar 2010
 Displaying page 1 of 1

### Excel templates and solutions matched for VLookup:

Solutions: Data Merge