I don't know how to insert an excel into the forum but I needed help with a formula. I was using vlookup but I need to now add multiple criteria.
Sheet 1
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I'm adding the formula to sheet 2 column A. I need to match the address and name from sheet 1 to return the ID to sheet 2. I'm working with a worksheet with over 2K rows and a lot of duplicate address values. Also if there is any way to partially match the name, for example Sheet 1 name is BMV Shop, sheet 2 only has BMV.
Any Help is appreciated.
Sheet 1
<tbody> </tbody> | |||||||||||
Sheet 2 |
<tbody>
</tbody>
ID | Address | Name |
123 State ST | BMV | |
123 State ST | ATPS |
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I'm adding the formula to sheet 2 column A. I need to match the address and name from sheet 1 to return the ID to sheet 2. I'm working with a worksheet with over 2K rows and a lot of duplicate address values. Also if there is any way to partially match the name, for example Sheet 1 name is BMV Shop, sheet 2 only has BMV.
Any Help is appreciated.