lookup,index-match,or-and-if type issue

  • Thread starter Thread starter Chad Linders
  • Start date Start date
C

Chad Linders

A B C D F
1 3 2 400 100
2 2 2 100 100
3 4 4 500 500
4 2 5 100 700
5 100
6 700

Ok in English: Column "C" relatad to "A" and "D" related
to "B". I need to match the "set" of #'s in F5 & F6 with
a set in columns C & D (C4 & D4 in this case). Then, in
another cell I need to shopw the value in column "A" which
is respective to "C" and "B" to "D". So....based on F5-
"100" and F6-"700", I need to display A4-"2" in one cell
and B4-"5"in another cell. It is important that the
initial search is done for a matching "set".

Sorry so long. Any help would be greatly appreciated.

Chad
 
A B C D E F G H
1 3 2 400 100 400.1
2 2 2 100 100 100.1
3 4 4 500 500 500.5
4 2 5 100 700 100.7
5 100 2
6 700 5

H1: =C1+D1/1000 to be copied downward
G5: =INDEX(A$1:A$4,MATCH(F$5+F$6/1000,H$1:H$4,0),1)
G6: =INDEX(B$1:B$4,MATCH(F$5+F$6/1000,H$1:H$4,0),1)
 
Back
Top