| Home > Forum Home > Developing Business Administration Solutions > VLookup > Concatenate then VLOOKUP | Share |
Concatenate then VLOOKUP
Excel Help for Concatenate Then Vlookup in Developing Business Administration Solutions
| Forum Topic | Login |
Concatenate Then Vlookup | Rate this: (2/5 from 4 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&B1 F1: =D1&C1 G1: =VLOOKUP(E1,$F$1:$F$7,1,FALSE) H1: =IF(G1<>"#N/A",TRUE,FALSE) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Concatenate then VLOOKUP in the Excel Business Solutions Directory |