Cross reference offset numbers

  • Thread starter Thread starter aresar
  • Start date Start date
A

aresar

I am trying to get data from the vlookup command, but my criteria i
very strict as to what I am looking for. I think I need to have th
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 an
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 &
have no significance)

If I put a function in Sheet 1, D2; I want to find the number fro
Sheet 2 that will give me the correct number for "2" in Sheet 1, A
that is associated with the "1" from Sheet 1, C3. The solution i
extracts from Sheet 2, Column G is 1200 because the "2" is associate
with the number "1" above it
 
=VLOOKUP(A1,Sheet2!B1:G100,6,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I think it has to be more than that. There are more values of "2" in
Sheet 2, Column B. need it to find the "2" associated with the
cooresponding number above it.

Any help is appreciated.
 
Back
Top