I am trying to get data from the vlookup command, but my criteria is very strict as to what I am looking for. I think I need to have the OFFSET function included, but I am not sure how.
Sheet 1
A B C D
2 2 1 (function)
3 3 2
4 4 3
2a 2a 2
2b 2b 2a
7 7 2
8 8 7
Column A or B is the number I want to reference in the formula and associate it with the number in Column C.
Sheet 2
A B C........G
X 2 X.......7700
X 7 X.......8600
X 8 X.......4200
X 1 X.......1000
X 2 X.......1200
X 3 X.......1400
X 4 X.......1100
X 2 X.......2100
X 2A X.......2400
X 2B X.......2200
The data I need to get is in Column G referencing Colum B(columns A & C have no significance)
If I put a function in Sheet 1, D2; I want to find the number from Sheet 2 that will give me the correct number for "2" in Sheet 1, A2 that is associated with the "1" from Sheet 1, C3. The solution it extracts from Sheet 2, Column G is 1200 because the "2" is associated with the number "1" above it.
Sheet 1
A B C D
2 2 1 (function)
3 3 2
4 4 3
2a 2a 2
2b 2b 2a
7 7 2
8 8 7
Column A or B is the number I want to reference in the formula and associate it with the number in Column C.
Sheet 2
A B C........G
X 2 X.......7700
X 7 X.......8600
X 8 X.......4200
X 1 X.......1000
X 2 X.......1200
X 3 X.......1400
X 4 X.......1100
X 2 X.......2100
X 2A X.......2400
X 2B X.......2200
The data I need to get is in Column G referencing Colum B(columns A & C have no significance)
If I put a function in Sheet 1, D2; I want to find the number from Sheet 2 that will give me the correct number for "2" in Sheet 1, A2 that is associated with the "1" from Sheet 1, C3. The solution it extracts from Sheet 2, Column G is 1200 because the "2" is associated with the number "1" above it.