S Shabbo Member Mar 6, 2018 #1 Dear Sir, I wanted to apply V lookup in Sheet2 V lookup with last 4 digit in sheet2 will also work. Attachments Vlookup.xls 16.5 KB · Views: 5
N NARAYANK991 Excel Ninja Mar 6, 2018 #2 Hi , Enter the following formula in cell B2 on Sheet2 , and copy down : =VLOOKUP("*" & RIGHT(A2, 4), Sheet1!$A$2:$A$6, 1, FALSE) Narayan
Hi , Enter the following formula in cell B2 on Sheet2 , and copy down : =VLOOKUP("*" & RIGHT(A2, 4), Sheet1!$A$2:$A$6, 1, FALSE) Narayan
