VLOOKUP formula and friend #N/A
sork
-
sork -
sork -
Hello,
I currently have a problem with this VLOOKUP formula.
Indeed, when I execute it [=VLOOKUP(H1,$Sheet32.A2:B56,2,1)]
I should be able to find in my cell what corresponds to Sheet32 for the number 1 that is in the first cell, based on my reference H1 (the number 1).
I don't know if you're following me; in any case, I've looked through some forums for a topic related to my situation. I thought it might be related to cell formatting—number, text, etc.—but that doesn't seem to be the case.
So, I have left you an example of the subject in Sheet 6.
Could you explain the cause of my problem so that I can understand my mistakes?
Thank you in advance
https://www.cjoint.com/c/ICBtnDW3icQ
Configuration: Windows / Chrome 72.0.3626.121
I currently have a problem with this VLOOKUP formula.
Indeed, when I execute it [=VLOOKUP(H1,$Sheet32.A2:B56,2,1)]
I should be able to find in my cell what corresponds to Sheet32 for the number 1 that is in the first cell, based on my reference H1 (the number 1).
I don't know if you're following me; in any case, I've looked through some forums for a topic related to my situation. I thought it might be related to cell formatting—number, text, etc.—but that doesn't seem to be the case.
So, I have left you an example of the subject in Sheet 6.
Could you explain the cause of my problem so that I can understand my mistakes?
Thank you in advance
https://www.cjoint.com/c/ICBtnDW3icQ
Configuration: Windows / Chrome 72.0.3626.121
6 réponses
Hello
In A1 sheet 6 there is:
=VLOOKUP(H1;$Sheet32.A2:B56;2;1)
it needs to be
in K1 sheet 6 there is:
=VLOOKUP(R1;$Sheet32.$A2:$Sheet32.$B78;2;1)
it needs to be:
The search range A2:B56 is not correct, it should be the range B2:B56
column B gives the number
column C gives the date
So search for the number in column B and return in the 2nd column, from the search range B2:C56, the date (Col C on Sheet 32).
The last argument of the function should be set to 0 instead of 1
However, the workbook seems corrupted because in A1 sheet 6 I only see the formula and not the result.
Maybe it's an original Excel workbook?
In A1 sheet 6 there is:
=VLOOKUP(H1;$Sheet32.A2:B56;2;1)
it needs to be
=VLOOKUP(H1;$Sheet32.B2:C56;2;0)
in K1 sheet 6 there is:
=VLOOKUP(R1;$Sheet32.$A2:$Sheet32.$B78;2;1)
it needs to be:
=VLOOKUP(R1;$Sheet32.$B$2:$C$78;2;0)
The search range A2:B56 is not correct, it should be the range B2:B56
column B gives the number
column C gives the date
So search for the number in column B and return in the 2nd column, from the search range B2:C56, the date (Col C on Sheet 32).
The last argument of the function should be set to 0 instead of 1
However, the workbook seems corrupted because in A1 sheet 6 I only see the formula and not the result.
Maybe it's an original Excel workbook?
Indeed, according to the value in H1, the value in sheet6 A1 should be the one from sheet32 A2, etc.
Can you help me understand this issue?
Actually, I'm having a strange bug too. Yet, I don't remember having changed from an xls to an odt....
Thank you.