Vlook up issue

Helllo guys ,
my First excel sheet IN121 is like this

Ref no_______LASA____ RF
123456789___yes
234537364___yes

Sec Excel sheet RF123 is like this

RF__________ Group
123456784___23
234537363___21

I have to search the first 8 digits of column RF from sheet RF123 and matches it to the first 8 digits of Column Ref no in IN121 sheet, then I have get the value of group from RF123 sheet into RF column of IN121

I have tried to do Vlook up and MID but unsuccessfull so far.


Any help will greatly appreciated.
Thanks

HI Ashin,

use below formula:-

Formula:

Please Login or Register  to view this content.

Enter this using ctrl shift enter key combinations

see attached:- vlookup basis partial number match.xlsx

Regards,
DILIPandey
<click on below * if this helps>

This is not pretty, but should do the job:

If what is being brought back is a number then:

Formula:

Please Login or Register  to view this content.

If it is text then:

Formula:

Please Login or Register  to view this content.

Both entered as Ctrl + Shift + Enter not just Enter
abousetta

Hi ashinSydney

Perhaps upload a small sample file, with dummy data.

If your using abousetta's second formula, have you entered it CTRL + SHIFT + ENTER.

See the attached file (the yellow cells).

Hi ashinSydney

Column E on sheet 100113. The formula in E2 has to be entered CTRL + SHIFT + ENTER the copied down. You can also wrap it in a IFERROR if needed.

Thanks Kevin. You are completely right. My formula works but only if you enter it as CSE instead of E only as it an array formula.