0

My col B has a value for each hour in C. I am trying to match get the value from B for matching value in A. I have tried out with XLOOKUP, but it gives 1 match and two N/A :s repeatedly (picture). Should i use another function or should it work with XLOOKUP. (Later will come values that are not aligned.) enter image description here

edit: Here is pictures of formulas in D3 and D4. (I wrote d3 and dragged down)

edit: Here are the formulas D3=XLOOKUP(A3;$C$3:$C$40;$B$3:$B$40) D4=XLOOKUP(A4;$C$3:$C$40;$B$3:$B$40)

enter image description here

enter image description here

Edit: As requested

LookupValue return_value LookupArray XLOOKUP
1.5.2023 0:00 31,51 1.5.2023 0:00:00 31,51
1.5.2023 1:00 31,49 1.5.2023 1:00:00 #N/A
1.5.2023 2:00 34,02 1.5.2023 2:00:00 #N/A
1.5.2023 3:00 36,69 1.5.2023 3:00:00 36,69
1.5.2023 4:00 39,89 1.5.2023 4:00:00 #N/A
1.5.2023 5:00 42,55 1.5.2023 5:00:00 #N/A
1.5.2023 6:00 44,83 1.5.2023 6:00:00 44,83
1.5.2023 7:00 47,89 1.5.2023 7:00:00 #N/A
1.5.2023 8:00 56,11 1.5.2023 8:00:00 #N/A
1.5.2023 9:00 65,55 1.5.2023 9:00:00 65,55
1.5.2023 10:00 50,09 1.5.2023 10:00:00 #N/A
1.5.2023 11:00 49,43 1.5.2023 11:00:00 #N/A
JaniH
  • 41
  • 3
  • what formula is in D3 and in D4 ? – Piemol Jun 19 '23 at 09:31
  • For us to understand what might be wrong, you need to at least share the formula you used that gives you the wrong result(s) – P.b Jun 19 '23 at 09:31
  • Show the formula. Check whether there are some seconds or not. if it does will give error. perhaps xlookup works `=XLOOKUP(C3,$A:$A,$B:$B)` – Γουλιέλμος Jun 19 '23 at 09:33
  • Added pictures of formulas – JaniH Jun 19 '23 at 10:27
  • 5
    Do NOT post pictures of formulas. See [Why should I not upload images of code/data/errors when asking a question?](https://meta.stackoverflow.com/questions/285551/why-should-i-not-upload-images-of-code-data-errors-when-asking-a-question) – Ron Rosenfeld Jun 19 '23 at 10:29
  • What do you see with `=A4=C4` – Ron Rosenfeld Jun 19 '23 at 10:32
  • @RonRosenfeld =A4=C4 gives TRUE (same on all fields in picture). I also checked that the underlying values (paste special) are same on A and C – JaniH Jun 19 '23 at 11:27
  • @JaniH use this please:https://www.tablesgenerator.com/markdown_tables# copy the data from your excel, then generate it and copy it back leaving a blank line in your question. – David Leal Jun 19 '23 at 17:08
  • I believe someone will need to examine your workbook in order to determine the problem. Unfortunately, your data as posted does not enable reproducing your problem. – Ron Rosenfeld Jun 27 '23 at 10:15

0 Answers0