Forum Discussion
Solved
VLOOKUP Issue, But on one item in the lookup table
I am working on refreshing my memory of Excel, as I have been using Libre for a few years now. I am working on sample data that has a Discount level. I did some Pivot Tables and decided that I want...
ChReed It seems likely that you want an exact match of your lookup value, so you should change your formula to this:
=VLOOKUP(E470,VLUPTables!$A$2:$B$5,2,FALSE)
FALSE at the end means that it needs to find an exact match. Without that, you would need to sort your data in ascending order.
ChReed It seems likely that you want an exact match of your lookup value, so you should change your formula to this:
=VLOOKUP(E470,VLUPTables!$A$2:$B$5,2,FALSE)
FALSE at the end means that it needs to find an exact match. Without that, you would need to sort your data in ascending order.
- Steve_SumProductCom That worked perfectly! Thank you so much. I thought had sorted the data already, but it was Alpha by Product and then by Discount Band. Not sure why the others worked, but this definitely fixed it. Thank you so much!
- I'm glad to hear that helped. Please mark my reply as Answer.
- Its already marked at Best Response so someone beat me too it! I thought there might be an "Answer" option, but I can only remove the Best Response notation. This is my first post, so if I am missing how to do this let me know! Thank you again!
