Hello there ;
If you can help me with a few problems in the code block below, I'd like to be happy.
• The searched value does not work if there is no number. I want to find mixed values in text, numbers and text.
• I want to search the table on the different page according to the following conditions.
o Example; If od export tab is od import ”from table in page1,
o Example; Working according to date range in column alı c “
o Example; In the column where the values are written, you should search only for those who do not.
If you can help me with a few problems in the code block below, I'd like to be happy.
• The searched value does not work if there is no number. I want to find mixed values in text, numbers and text.
• I want to search the table on the different page according to the following conditions.
o Example; If od export tab is od import ”from table in page1,
o Example; Working according to date range in column alı c “
o Example; In the column where the values are written, you should search only for those who do not.
Code:
Sub FastestVlookup()
[COLOR=#212121][FONT=inherit][CODE][/FONT][/COLOR]
Sub FastestVlookup()
With Sayfa2.Range("c3:c" & Range("A3").End(xlDown).Row)
.FormulaR1C1 = _
"=IF(VLOOKUP(RC2,Sayfa2!R3C9:R20700C11,1)=RC2,VLOOKUP(RC2,Sayfa2!R3C9:R20700C11,3),""N/A"")"
.Value = .Value
End With
End Sub