Hi all,
i using a formula Hlookup(C5,VL,A7,FALSE) is not working. can anybody tell me why? i use this sheet2 d8 cell. VL is the range of sheet1 d4 to s65. i want to change date c5 in sheet2 data pick AUTO from sheet1 as mention in sheet2 C8.
Sheet1,
sheet2,