How to find a result when you need to search a number of columns

Is there no way of searching the two columns A and B in Sheets 1 to identify the look up value either 4G,5G,AZ,ZZ the reason I ask is because there will not always be a 'G' in the area, it could be varied but will never have the exact same letters and numbers. If I could look up the two columns it would make it much easier for me, in the report i'm going to build there could be 20 different codes in Area(column A) and even more codes in Site(column B).

Change formula to:

=IFERROR(INDEX(Sheet1!$F$2:$F$29,MATCH(1,(Sheet1!$A$2:$A$29=$C$2)*(Sheet1!$C$2:$C$29=$B5)*(Sheet1!$E$2:$E$29=C$4),0)),INDEX(Sheet1!$F$2:$F$29,MATCH(1,(Sheet1!$B$2:$B$29=$C$2)*(Sheet1!$C$2:$C$29=$B5)*(Sheet1!$E$2:$E$29=C$4),0)))

copied and press CTRL-SHIFT-ENTER button together

and drag down and cross

Thanks Azumi that is exactly what I am looking for. Really appreciate your help.

Yes you're welcome, happy to help