Formula to search in a big table

[Hasse]

Hi,

If I have a table like this but with columns all the way to AP. How can I write a formula so that I can search for a for value in column B, D, F etc down to column AO to get a return value from the column to the right

/Hasse

A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	30001	22855	30201	22998	30401	?
2	30002	22856	30202	22999	30402	?
3	30003	22857	30203	23000
4	30004	22858	30204	23001
5	30005	22859	30205	23002
6	30006	22860	30206	23003
7	30007	22861	30207	23004
8	30008	22862	30208	23005
9	30009	22863	30209	23006
10	30010	22864	30210	23007
11	30011	22865	30211	23008
12	30012	22866	30212	23009
13	30013	22867	30213	23010
14	30014	22868	30214	23011
15	30015	22869	30215	23012
16	30016	22870	30216	23013

<tbody>
</tbody>

 

[Hasse]

…and if you wanna see the solution have a look in this thread

https://www.mrexcel.com/forum/excel-questions/1037726-look-up-value.html?highlight=hasse