Value in the adjacent column of the queried column.

[Rumburak]

Howdy,

If anyone can help me ...
In column A there are item names, in column B are numbers.
In columns I, K, M and O are numbers and in the columns adjacent to the columns mentioned, ie J, L, N and P can be numbers and text.
I wrote in column C the desired results.

Example. I'm looking for the number 125 in column B, for the AAA name in the first table, in table 2, in the column adjacent to the AAA column, column J, here number 144.
If we look for 337 in the column adjacent to the TZAR column, that is column P, they find the number 714.

col A col B col C
[TABLE="width: 157"]
<colgroup><col width="82" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2901;"> <col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 82, bgcolor: transparent"]RKM Name[/TD]
[TD="width: 64, bgcolor: transparent"]Dim[/TD]
[TD="width: 64, bgcolor: transparent"]Result[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AAA[/TD]
[TD="bgcolor: transparent"]125[/TD]
[TD="bgcolor: transparent"]444[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AAB[/TD]
[TD="bgcolor: transparent"]149[/TD]
[TD="bgcolor: transparent"]777[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AZK[/TD]
[TD="bgcolor: transparent"]211[/TD]
[TD="bgcolor: transparent"]444[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]TZAR[/TD]
[TD="bgcolor: transparent"]337[/TD]
[TD="bgcolor: transparent"]714[/TD]
[/TR]
</tbody>[/TABLE]


col I col J col K col L col M col N col O col P
[TABLE="width: 272"]
<colgroup><col width="46" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1621;" span="8"> <tbody>[TR]
[TD="width: 46, bgcolor: transparent"]AAA[/TD]
[TD="width: 46, bgcolor: transparent"][/TD]
[TD="width: 46, bgcolor: transparent"]AAB[/TD]
[TD="width: 46, bgcolor: transparent"][/TD]
[TD="width: 46, bgcolor: transparent"]AZK[/TD]
[TD="width: 46, bgcolor: transparent"][/TD]
[TD="width: 46, bgcolor: transparent"]TZAR[/TD]
[TD="width: 46, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]87[/TD]
[TD="bgcolor: transparent"]200[/TD]
[TD="bgcolor: transparent"]210[/TD]
[TD="bgcolor: transparent"]XKL[/TD]
[TD="bgcolor: transparent"]211[/TD]
[TD="bgcolor: transparent"]444[/TD]
[TD="bgcolor: transparent"]14[/TD]
[TD="bgcolor: transparent"]164[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]21[/TD]
[TD="bgcolor: transparent"]NotK[/TD]
[TD="bgcolor: transparent"]199[/TD]
[TD="bgcolor: transparent"]100[/TD]
[TD="bgcolor: transparent"]45[/TD]
[TD="bgcolor: transparent"]333[/TD]
[TD="bgcolor: transparent"]19[/TD]
[TD="bgcolor: transparent"]NacD[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]125[/TD]
[TD="bgcolor: transparent"]444[/TD]
[TD="bgcolor: transparent"]125[/TD]
[TD="bgcolor: transparent"]177[/TD]
[TD="bgcolor: transparent"]39[/TD]
[TD="bgcolor: transparent"]300[/TD]
[TD="bgcolor: transparent"]337[/TD]
[TD="bgcolor: transparent"]66[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]337[/TD]
[TD="bgcolor: transparent"]121[/TD]
[TD="bgcolor: transparent"]149[/TD]
[TD="bgcolor: transparent"]777[/TD]
[TD="bgcolor: transparent"]100[/TD]
[TD="bgcolor: transparent"]200[/TD]
[TD="bgcolor: transparent"]377[/TD]
[TD="bgcolor: transparent"]714[/TD]
[/TR]
</tbody>[/TABLE]


Thanks.

 

[Ingolf]

Example. I'm looking for the number 125 in column B, for the AAA name in the first table, in table 2, in the column adjacent to the AAA column, column J, here number 144.

Should not be 444??
Data in column with header AAA, AAB, AZK and TZAR are unique or not?

 

[Peter_SSs]

Is this what you want?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	RKM Name	Dim	Result						AAA		AAB		AZK		TZAR
2	AAA	125	444						87	200	210	XKL	211	444	14	164
3	AAB	149	777						21	NotK	199	100	45	333	19	NacD
4	AZK	211	444						125	444	125	177	39	300	337	66
5	TZAR	337	66						337	121	149	777	100	200	377	714
Lookup

 

[Rumburak]

@Ingolf
You're right
@Peter_SSs
Thank you so much.

 

[Peter_SSs]

@Peter_SSs
Thank you so much.

Glad to help.