Ilounah 2 Posted March 8 Share Posted March 8 (edited) Im using a Vlookup on another sheet to fetch the data of Time entry but only works on row 5, because I use C5 as lookup_value in Vlookup. Any suggestion how can i fetch row6 on wards using c5 as lookup_value? Thanks 😁 Edited March 8 by Ilounah Link to post Share on other sites
ioa747 105 Posted March 8 Share Posted March 8 (edited) I assume you are not using a script, otherwise you would show it to us simply by changing the first parameter of Vlookup if I understood correctly what you want https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 I hope it helps Edited March 8 by ioa747 Link to post Share on other sites
Ilounah 2 Posted March 8 Author Share Posted March 8 Hello @ioa747 The problem is C6,C7,C8 etc does not have a value like C5 so i cannot use Vlookup withou a lookup value, if im gonna put value on c6 on wards it will take my time due to more employees 😅 Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now