Lookup 2 columns to the right

[valmir]

Hello Everyone. I came up with this formula but I have a little dilemma here. Because sometimes I need to swap every three columns, I need a formula that will always point me to the data on the second column to the right of the reference column. My formulas in O5:O10 will no longer work in case I move columns B, C and D (I always move all 3 columns at once)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		1			2			3			4
2
3
4
5	Michael			F						Q					F
6	John						O			T					0
7	Claire														0
8	Angel			H									U		H
9	Bjorg														0
10	Smith						P								0
Sheet1

Cell Formulas
Range	Formula
O5:O10	O5	=LOOKUP(1,$B$1:$M$1,D5)

 

[valmir]

This is the solution that was provided to me. I hope that it helps someone else looking for the same thing. In this case, for the first cell, it should be:
=INDEX(Sheet1!$B$1:$O$10;MATCH($A5;Sheet1!$A$5:$B$10;0);MATCH(B$1;Sheet1!$B$1:$O$1;0)+2)