# Row-and-Column Lookup

#### srizki

##### Well-known Member
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.
Lookup Functions.xls
ABCDEFGH
1PartNumberC-321
2FieldNameQuantity
3Value298
4General
5PartsDatabase
6DivisionDescriptionQuantityCostTotalCostRetailGrossMarginNumber
74GangleyPliers57\$10.47\$596.79\$17.9571.4%D-178
83HCABWasher856\$0.12\$102.72\$0.25108.3%A-201
93FinleySprocket357\$1.57\$560.49\$2.9587.9%C-098
1026"Sonotube86\$15.24\$1,310.64\$19.9530.9%B-111
114Langstrom7"Wrench75\$18.69\$1,401.75\$27.9549.5%D-017
123ThompsonSocket298\$3.11\$926.78\$5.9591.3%C-321
131S-Joint155\$6.85\$1,061.75\$9.9545.3%A-182
142LAMFValve482\$4.01\$1,932.82\$6.9573.3%
Row-and-Column Lookup

Thanks

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### srizki

##### Well-known Member
I just copy and paste format and it is working fine. Thanks for looking my post.

Replies
3
Views
58
Replies
9
Views
82
Replies
6
Views
101
Replies
3
Views
52
Replies
5
Views
48

1,109,423
Messages
5,528,681
Members
409,829
Latest member
CFreeamaz

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...