Using VLOOKUP any idea for HELPER

[Ilounah]

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, 2023 by Ilounah

[ioa747]

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, 2023 by ioa747

[Ilounah]

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 😅

[Skeletor]

If you still searchign for this solution, Try this. I have not tried it but based off your explanation:

=VLOOKUP(C6;VLOOKUP(C5;RemoteSheetA:Z;3;0);3;0)

and since you mentioned onwards, used this:

=VLOOKUP(C6;VLOOKUP($C$5;RemoteSheetA:(Z);3;0);3;0)