VLOOKUP or INDEX-MATCH to assign appropriate category

[bxk006]

Good Morning,

I need help writing a formula to automatically assign a category based on a reference table located on another sheet. I have tried writing vlookup or index-match formulas, but it won't search the table and return the correct category (just returns #N/A).

I want to search the reference table for a match of cell c3 (April 12b-1 Billing - UMBDS Minimum) and return the category (Other) next to it onto my main sheet. File is attached.

Thanks!

[Ace_XL]

In A3

=INDEX('Reference Table'!$A$3:$A$7,MATCH(C3,'Reference Table'!$C$3:$C$7,0))

Copy down

[wfm007]

Use this one:

Please Login or Register  to view this content.

[bxk006]

Thanks wfm! Appreciate the quick reply.