Double Sheet Vlookup help

[Nabeel]

Hello all

Plz find attached. In file there is two sheet new and old codes. I want in sheet 3 when I give code the data appear either that code in old code sheet or new code sheet. Both sheets has different sequence or heading and will change index num self in formula according to my req.

BR

 

[Luke M]

Hi Nabeel,

I'd setup an IF statement to check whether to look at new or old sheet. Perhaps something like:
=IF(LEN(A2)>=5,VLOOKUP(A2,NewCodeSheet,...),VLOOKUP(a2,OldCodeSheet,...))

 

[Hui]

BR
I used a different approach like:
=IFERROR(INDEX(O_Name,MATCH($A2,O_EmpCode,0)),INDEX(N_Name,MATCH($A2,N_EmpCode,0)))

Using named Ranges for all the data

Please see attached

 

[Nabeel]

Hello Hui
its is working little change req..in sheet 3 at payroll group column it should show Grade of new codes sheet instead of dash.
BR

 

[Hui]

I am sure you can work out what to do
Look at other formulas