I have a workbook where I have a column 'site no.' where I'd like to be able to type a 3 digit number & the column 'site address' is auto filled with the address. site numbers & site address's are on sheet 2.
Site No. Site address 722 A4074 Warborough
Site No. column is
sheet1! G:G, that's the place I want to start typing 3 digit site address.
Sheet2! A:A is where site numbers are
sheet2! B:B is where the address is &
sheet1! H:H is where I want the address to enter.