Hi All
Im going a little crazy after working about 18 hours infront of the same excel workbook.
Im trying to do a database style lookup from a reference table matching on a combination of three columns (A, B, and C in the large table), and placing the value of D next to each row.
My formula works when I try with a small 4 row test table:
{=INDEX(T127:T129,(MATCH(1,(Q127:Q129=Q134)*(R127:R129=R134)*(S127:S129=S134),0)))}
When I try and convert to the large 3000 row proper table I get an #N/A
{=INDEX('Rate Lookup'!D2:D31,(MATCH(1,('Rate Lookup'!A2:A31=Q133)*('Rate Lookup'!B2:B31=R133)*('Rate Lookup'!C2:C31=S133),0)))}
Any ideas?
Bookmarks