Lookup - Exact Match

Hi all,

I'm looking for help on which function to use for the following problem as LOOKUP doesn't seem to be able to do exactly what I want.

I need to use a 'Lookup' type function which will only find an exact match from a list of data, if an exact match is not found I need it to return an error or empty or something.

This is the current function/expression which I'm using:

LOOKUP(B13,SData!A2:A5007,SData!C2:C5007)

Can anyone suggest anything?

Many thanks,
Anth

You should use Vlookup. Your formula will be something like:
=VLOOKUP(B13,SData!A2:C5007,3,FALSE)
which means that you want the values in the third column from range A2:C5007, where FALSE means that you want an exact match.

Thank you, that is exactly what I need

Anth