rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
I have a value, PTBCPWOM003. To do a lookup on another sheet which has the actual value as BCPWOM003, how to modify my Vlookup.
There are quite a few entries which have the first two characters missing. How to do a Like or a mid or len to compare BCPWOM003 against PTBCPWOM003?
something like , If value of C1 = PTBCPWOM003 then (MID(C1,3,9)) = BCPWOM003
Currently, I use a VLookup
Few values in AG have two characters missing but in the second sheet, HQLA they have the complete value.
There are quite a few entries which have the first two characters missing. How to do a Like or a mid or len to compare BCPWOM003 against PTBCPWOM003?
something like , If value of C1 = PTBCPWOM003 then (MID(C1,3,9)) = BCPWOM003
Currently, I use a VLookup
VBA Code:
ws.Range("BE2:BE" & ws.Cells(Rows.Count, "AG").End(xlUp).Row).FormulaR1C1 = "=VLOOKUP(""*""&RC[-24]&""*"",HQLA!C1:C4,4,0)"
Few values in AG have two characters missing but in the second sheet, HQLA they have the complete value.
Last edited by a moderator: