VLookup

[amitmodi_mrt]

Hi,

I have a sheet in which I data in Colunm A,D,G,and J. I trying to do a vlookup in colunm O2 for the value I have in column N2. I looking for a formula that can search for the value that is in N2 and show if it is cT,cC,or cB it in column O2 (these values are in column B,E,H, or K) Please see the attached sheet.

I triedvarious combinations of vlookup but couldnt make it. Please help me in this.

Regards,
Amit.

[DP978]

There is no way to combine all 4 Table?

This way you could use 1 Vlookup....