gurpreet161
New Member
- Joined
- Jan 2, 2005
- Messages
- 11
Hi,
I would like some assistance with help in value lookup. There are 2 factors involved so I was not able to work with single lookup.
I am pasting a table array of A1:H19. I have added the an additional column to the left to list the row number and row at the top to list the column number.
I am trying to find a formula where we first look for ABC (5.5) in the second row and then look for XYZ in the previous column (previous to the one where ABC is located) and then pick up the value from the next to the XYZ.
A1 B C D E F G H I
2 ABC 5.375 ABC 5.5
3 XYZ VALUE XYZ VALUE
4 5.5 0.004632 5.625 0.009457 ABC 5.5
5 5.625 0.0089425 5.75 0.013505 XYZ 6.75
6 5.75 0.012617 5.875 0.0163845
7 5.875 0.0150975 6 0.003768
8 6 0.003456 6.125 0.007056
9 6.125 0.006468 6.25 0.009768
10 6.25 0.008954 6.375 0.0112365
11 6.375 0.0100485 6.5 0.002664
12 6.5 0.002448 6.625 0.004998
13 6.625 0.0046305 6.75 0.006993
14 6.75 0.006549 6.875 0.0074745
15 6.875 0.00693 7 0.002004
16 7 0.00192 7.125 0.00392
17 7.125 0.003773 7.25 0.005698
18 7.25 0.00555 7.375 0.006039
19 7.375 0.0058905 7.5 0.001752
I know it would be simple for many but I have learnt a lot through this message board and I appreciate everyone's help all the time.
Thank you.
Vickie
I would like some assistance with help in value lookup. There are 2 factors involved so I was not able to work with single lookup.
I am pasting a table array of A1:H19. I have added the an additional column to the left to list the row number and row at the top to list the column number.
I am trying to find a formula where we first look for ABC (5.5) in the second row and then look for XYZ in the previous column (previous to the one where ABC is located) and then pick up the value from the next to the XYZ.
A1 B C D E F G H I
2 ABC 5.375 ABC 5.5
3 XYZ VALUE XYZ VALUE
4 5.5 0.004632 5.625 0.009457 ABC 5.5
5 5.625 0.0089425 5.75 0.013505 XYZ 6.75
6 5.75 0.012617 5.875 0.0163845
7 5.875 0.0150975 6 0.003768
8 6 0.003456 6.125 0.007056
9 6.125 0.006468 6.25 0.009768
10 6.25 0.008954 6.375 0.0112365
11 6.375 0.0100485 6.5 0.002664
12 6.5 0.002448 6.625 0.004998
13 6.625 0.0046305 6.75 0.006993
14 6.75 0.006549 6.875 0.0074745
15 6.875 0.00693 7 0.002004
16 7 0.00192 7.125 0.00392
17 7.125 0.003773 7.25 0.005698
18 7.25 0.00555 7.375 0.006039
19 7.375 0.0058905 7.5 0.001752
I know it would be simple for many but I have learnt a lot through this message board and I appreciate everyone's help all the time.
Thank you.
Vickie