I have data in A1:A47. and data in B1:H101. In these two range of data the common data return to I coloumn. I need a formula to do this. Please help me.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Match the value of multiple coloumn
0
Answers
0
There is probably an annoying formula way to do this but there is also a simple VBA/Macro solution:
Sub check_values()
For a = 1 To 41
checkValue = Cells(a, 1).Value
For i = 1 To 101
For n = 2 To 8
If checkValue = Cells(i, n).Value And Cells(i, n) <> "" Then
Cells(a, 9).Value = "Yes"
End If
Next n
Next i
Next a
End SubIt may seem complex but it's just a few loops that go through your data and output Yes in column I in the row where the value in column A was located in the range B1:H101.