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).
Bookmarks