How to make an Hlookup?

[Jyggalag]

Hi all,

I currently have this:

I want to hlookup the value in my other table based on the date in column A (01-06-2022)

It should return the value here:

However, I do not know how to get it to return the value of 175937,93?

I tried to put in "955" as the column index number... but it just returns #N/A no matter what I insert

can somebody please help?

Thanks!

 

[Peter_SSs]

Will the Grand Total always be on row 955?

 

[Jyggalag]

Will the Grand Total always be on row 955?

Yes

 

[Peter_SSs]

Then try

=HLOOKUP(A2,Sheet4!$B$2:$BR$955,954,0)

 

[Jyggalag]

I

Then try

=HLOOKUP(A2,Sheet4!$B$2:$BR$955,954,0)

It does not work Am i doing something wrong?

 

[Peter_SSs]

Could it be that your date in A2 is Text and the dates in row 2 of Sheet4 are Numeric? Or vice-versa?

 

[Jyggalag]

Could it be that your date in A2 is Text and the dates in row 2 of Sheet4 are Numeric? Or vice-versa?

That is true! In my first sheet the dates are "Date" and in the second one they are "General"

 

[Jyggalag]

I t

Could it be that your date in A2 is Text and the dates in row 2 of Sheet4 are Numeric? Or vice-versa?

I turned it from "Date" to "General" and it works now!

Thank you so much for your brilliant insight Peter! I could never have guessed that myself haha

 

[Peter_SSs]

second one they are "General"

They may be formatted as "General" but think the actual value is most likely Text. It certainly looks that way as those dates in Sheet4 are left-aligned like Text would be.
With the original formatting you could try this.

=HLOOKUP(TEXT(A2,"dd-mm-yyyy"),Sheet4!$B$2:$BR$955,954,0)