I'm having some trouble with a formula that I'm hoping to get your thoughts on.

AZ1 = Sheet1
AZ = Sheet 2

'AZ1'!C2 = Cell Value that I'm trying to compare

'AZ'!C:C = Range that I'm comparing with

'AZ'!H:H = Holds cell Value that I'm trying to copy, if 'AZ1'!C2 = a match in 'AZ'!C:C.

I've tried using vLookup, Match, and If functions to make it work but keep running into errors. Any help would be amazing!