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
<tbody>
</tbody>
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>