rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hi,
For my sheet, I need to lookup values from two different columns.
Using one column, I get values.
ws.Range("AU2:AU" & ws.Cells(Rows.Count, "Y").End(xlUp).Row).FormulaR1C1 = "=VLOOKUP(""*""&RC[-22]&""*"",HQLA!C1:C35,35,0)"
Also, I need to read it from the Column, C3 of HQLA.
How to use the below along with the above
ws.Range("AU2:AU" & ws.Cells(Rows.Count, "Y").End(xlUp).Row).FormulaR1C1 = "=VLOOKUP(""*""&RC[-22]&""*"",HQLA!C3:C35,35,0)"
Using C1, I get values like IG-1, N-2.
For missing values, "#N/A",I need it to read from Col, C3.
For my sheet, I need to lookup values from two different columns.
Using one column, I get values.
ws.Range("AU2:AU" & ws.Cells(Rows.Count, "Y").End(xlUp).Row).FormulaR1C1 = "=VLOOKUP(""*""&RC[-22]&""*"",HQLA!C1:C35,35,0)"
Also, I need to read it from the Column, C3 of HQLA.
How to use the below along with the above
ws.Range("AU2:AU" & ws.Cells(Rows.Count, "Y").End(xlUp).Row).FormulaR1C1 = "=VLOOKUP(""*""&RC[-22]&""*"",HQLA!C3:C35,35,0)"
Using C1, I get values like IG-1, N-2.
For missing values, "#N/A",I need it to read from Col, C3.