Vlookup help, i think that is what I should use.

[rbyland]

I need some assistance with Vlookup. I have a data validation list (drop down list) that I am orking with. I want to have a value written in the next cell when you choose a certain criteria from the drop down. I have the information for the drop down and the criteria on the 2nd sheet and haven't been able for it to come out correctly.

=LOOKUP(C6,Sheet4!A2:A38,Sheet4!B2:B38)

C6 is the list to match to Sheet4!a2:a38, if that matches to those it should show the input on Sheet4!B2:B38.

Hope that isn't too confusing.

 

[VoG]

Try

=LOOKUP(C6,Sheet4!A2:B38,2,FALSE)

 

[rbyland]

It says I have entered too many agruments for this function.

 

[Sanjeev1976]

It says I have entered too many agruments for this function.

Use =LOOKUP(C6,Sheet4!A2:B38,2) and it should work well.

 

[VoG]

Sorry

=VLOOKUP(C6,Sheet4!A2:B38,2,FALSE)

 

[rbyland]

Thanks, that worked great.

Last question

If nothing is in the c6 cell, could I use an

=if(c6>0,(VLOOKUP(C6,Sheet4!A2:B38,2,FALSE),"")

To hide the #N/A that appears?

 

[Sanjeev1976]

Thanks, that worked great.

Last question

If nothing is in the c6 cell, could I use an

=if(c6>0,(VLOOKUP(C6,Sheet4!A2:B38,2,FALSE),"")

To hide the #N/A that appears?

Use =if(iserror(VLOOKUP(C6,Sheet4!A2:B38,2,FALSE)),"",VLOOKUP(C6,Sheet4!A2:B38,2,FALSE))

This would hide the #N/A error

 

[rbyland]

Thank you