Hello Experts, I need ur help with this Vlookup Formula
The formula doesn't tie up with what you have written - the formula is
looking to match B3 with cells in column A and F3 with cells in row
16, whereas you mention B7 (only) in your description. Also, the
formula expects data up to column I, but only in 3 rows.
However, I have set up this table so that it occupies A16 to F20:
a b c d e
0 25 26 27 38 48
0.5 32 34 39 42 49
1.0 36 39 41 45 52
1.51 39 43 49 52 56
Then I used A7 to enter the values a, b, c, d or e (equivalent to your
F3 ?) and B7 to enter numbers, and in C7 I put this formula:
=INDEX($B$17:$F$20,MATCH(B7,$A$17:$A$20),MATCH(A7, $B$16:$F$16,0))
It returns the corresponding value from the table, depending on A7 and
B7. You might like to extend the ranges to suit your data.
Hope this helps.
Pete
On Nov 26, 7:37*pm, Kinghart wrote:
OK Pete....
I have a table like this
< * * * * * * * *a * * *b * * * c * * * d * * * *e *
0-0.5 * * * * *25 * * 26 * * 27 * * *38 * * *48
0.5-1.00 * * *32 * * 34 * * 39 * * *42 * * 49
1.00-1.50 * *36 * * *39 * *41 * * *45 * * 52
1.51-2.00 * *39 * * *43 * *49 * * *52 * * 56
I want C7 to show 41 when i type 1.10 or 1.30 or 1.49 in B7
I'm using a formula like this:
=INDEX($B$17:$I$19,MATCH(B3,$A$17:$A$19,0),MATCH(F 3,$B$16:$I$16,0))
But that formula only works when i write 1.00 and 1.50 in B7... (not
1.10 or 1.20 or 1.23)
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
--
Kinghart
|