Searching Range for Exact Match

Heres one ive been messing with for awhile and cant figure out it seems so easy yet im getting no where quick.

I want to search the range of cells A50:A1750 for a Serial Number in A1 if found i want B1 ( where the formula is ) to return the infomation in column C of the row found for example:

I Want B1 to Return Column C of the row that matches A1


A1 = Test
A1125 = Test
C1125 = Good

B1 should return Good

Thanks for the help hopefully this make sense to all you out there.

Without an error check, try this:

Please Login or Register  to view this content.

Cheers,

=INDEX(C50:C1750, MATCH(A1, A50:A1750, 0)) if you require an exact match.

Or =INDEX(POE!$I$1:$I$1750, MATCH(A7, POE!$A$1:$A$1750, 0))

... or

=VLOOKUP(A7, POE!$A$1:$I$1750, 9, FALSE)