Using VLOOKUP any idea for HELPER

[Ilounah 2]

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

[ioa747 105]

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

[Ilounah 2]

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 😅