Sorry if this is a repost--- The first one may not have actually made it.

I have an array A1:C10 on an existing worksheet. I need a look up function
where by I can enter a vlue that would be found in ColC and return the
corresponding value from ColA. Can this be done without having to copy and
paste a new table with the standard vlookup orientation?
Thanks!