Search results

Hi, I got a row number, say row 315, then i try to start vlookup from that row to the end. So my formula will look like: =vlookup(A1,$B$315:$D$500,2,0) however, row 315 is a dynamic cell depends on the result i generate in another cell, e.g. cell B1. Cell B1 contains the exact row number (e.g...

Hi, I have the following table for value lookup. Actually, a user has 2 criteria, i) what Big group he is in; ii) what sub group he is in under the Big group. Then based on these 2 criteria, lookup what fruit he needs. For example, User is in i) B-2 Big group; and ii) be-2 subgroup, then he...

Hi all, I am quite new to VBA and i wrote the following function. I try to double check if there is any double booking for a time slot. And now i need to add if the room is available, but i am still stuck how to add the room availability logic. Could someone please help? Thanks in advance...