| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help matching combined text cells
I'm trying to do a VLOOKUP based on a combination of cells...
In Sheet1: column B is a 4 digit number column G is text =B7&""&G7 ....which looks like "3433Roofs" In a sheet named AcivicoTable: column B3:B96 is the same 4 digit numbers column D3:D96 is text So I need a formula that will look up the combination of text cells from sheet one against all of the combination of text cells in sheet 2 i.e... =IF(VLOOKUP(B7&""&G7,AcivicoTable!B3&""&B3:D96&""& D96,1,FALSE),"Yes","No") I doubt whether a VLOOKUP can even do this to be honest so any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of rows with 2 matching text cells | Excel Worksheet Functions | |||
| Sorting cells with Combined Text and Numbers | Excel Discussion (Misc queries) | |||
| Matching text in cells | Excel Discussion (Misc queries) | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Compare cells/columns and highlight matching text strings | Excel Worksheet Functions | |||
Threaded Mode
