srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,839
- Office Version
- 365
- Platform
- Windows
I have the following formula,
=INDEX(A7:H14, MATCH(B1, H7:H14, 0), MATCH(B2, A6:H6, 0))
In B3 , that gives correct result.
But, if I put the same formula any where else it gives me result “General”, I am puzzled why is that although formula is exactly the same.
here is the sample worksheet.
Thanks
=INDEX(A7:H14, MATCH(B1, H7:H14, 0), MATCH(B2, A6:H6, 0))
In B3 , that gives correct result.
But, if I put the same formula any where else it gives me result “General”, I am puzzled why is that although formula is exactly the same.
here is the sample worksheet.
Lookup Functions.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | PartNumber | C-321 | ||||||||
2 | FieldName | Quantity | ||||||||
3 | Value | 298 | ||||||||
4 | General | |||||||||
5 | PartsDatabase | |||||||||
6 | Division | Description | Quantity | Cost | TotalCost | Retail | GrossMargin | Number | ||
7 | 4 | GangleyPliers | 57 | $10.47 | $596.79 | $17.95 | 71.4% | D-178 | ||
8 | 3 | HCABWasher | 856 | $0.12 | $102.72 | $0.25 | 108.3% | A-201 | ||
9 | 3 | FinleySprocket | 357 | $1.57 | $560.49 | $2.95 | 87.9% | C-098 | ||
10 | 2 | 6"Sonotube | 86 | $15.24 | $1,310.64 | $19.95 | 30.9% | B-111 | ||
11 | 4 | Langstrom7"Wrench | 75 | $18.69 | $1,401.75 | $27.95 | 49.5% | D-017 | ||
12 | 3 | ThompsonSocket | 298 | $3.11 | $926.78 | $5.95 | 91.3% | C-321 | ||
13 | 1 | S-Joint | 155 | $6.85 | $1,061.75 | $9.95 | 45.3% | A-182 | ||
14 | 2 | LAMFValve | 482 | $4.01 | $1,932.82 | $6.95 | 73.3% | |||
Row-and-Column Lookup |
Thanks