Compare 2 columns, in Seprate Sheets, for same name. If Match = Value of Cell 3 to right

[kfdavis512]

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!

[Pete_UK]

Try this:

=IFERROR(VLOOKUP('AZ1'!C2,'AZ'!C:H,5,0),"not present")

Hope this helps.

Pete