VLOOKUP Function Problems

[caos88]

Hello everyone,

I wish to auto-populate the cells by selecting any value from a drop down menu that i have created. i try to have =VLOOKUP(I4,'Sheet2'!A4:F25,4,FALSE). I4 is where i have the drop down menu, 'Sheet2'!A4:F25 is where i have table with the information that i want to auto populate, 4 is the column of the value that i want to show when the drop down menu is used and false is for the exact value. Unfortunately i have #N/A as a result. What i do wrong ?

 

[DanteAmor]

You can put here the data you have in I4 and a sample of what you have in the range Sheet2'!A4:F25
Use XL2BB tool, see my signature.

 

[caos88]

You can put here the data you have in I4 and a sample of what you have in the range Sheet2'!A4:F25
Use XL2BB tool, see my signature.

You can put here the data you have in I4 and a sample of what you have in the range Sheet2'!A4:F25
Use XL2BB tool, see my signature.

 

[DanteAmor]

Unfortunately your images are not complete, I don't see the rows and columns of excel.
But I can assume that in column B you have the Names, so your formula should start in B like this:

=VLOOKUP(I4,'Sheet2'!B4:F25,4,FALSE)

Now I'm not sure if you want the result from column E or the one from column F.
If you want the one in column F then 4 is fine, but if you want the one in column E then change to 3.

 

[caos88]

Unfortunately your images are not complete, I don't see the rows and columns of excel.
But I can assume that in column B you have the Names, so your formula should start in B like this:

=VLOOKUP(I4,'Sheet2'!B4:F25,4,FALSE)

Now I'm not sure if you want the result from column E or the one from column F.
If you want the one in column F then 4 is fine, but if you want the one in column E then change to 3.

Hello,

Thank you @DanteAmor, now is working fine.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.