Excel Query - Matching more than variable
Closed
Kit
-
Jul 11, 2012 at 03:40 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 17, 2012 at 09:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 17, 2012 at 09:27 AM
Hello,
Hope you can help!
I am trying to match two values in two seperate columns and then return the value in the third column? For instance if column A is forenames, Column B is surnames and Column C is an address, although there are duplications in column A & B individually there is only one John Smith.
I'd like to avoid using &" "& to join Column A & B together to create one data column to search through but can't think of any other way. Thanks in advance
Cheers
Kit
Hope you can help!
I am trying to match two values in two seperate columns and then return the value in the third column? For instance if column A is forenames, Column B is surnames and Column C is an address, although there are duplications in column A & B individually there is only one John Smith.
I'd like to avoid using &" "& to join Column A & B together to create one data column to search through but can't think of any other way. Thanks in advance
Cheers
Kit
Related:
- Excel Query - Matching more than variable
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 17, 2012 at 09:27 AM
Jul 17, 2012 at 09:27 AM
Hi Kit,
See if this is to your liking:
Best regards,
Trowa
See if this is to your liking:
Sub SearchAddress() Dim fName, lName As String Dim lRow As Integer fName = InputBox("Please input first name.") lName = InputBox("Please input last name.") lRow = Range("A" & Rows.Count).End(xlUp).Row For Each cell In Range("A1:A" & lRow) If cell.Value = fName And cell.Offset(0, 1).Value = lName Then MsgBox cell.Offset(0, 2).Value, vbOKOnly, "The address for " & fName & lName & " is:" End If Next cell End Sub
Best regards,
Trowa