Forum Discussion

KellyZachari's avatar
KellyZachari
Copper Contributor
Feb 20, 2022

Vlookup

Hello. I have two worksheets in excel. With the first one there is a list of store numbers in the 1st column on the left, the second column is blank for store names, the third column has their sales for the year and the fourth column has projected sales at a 10% increase. On the second worksheet I have a list of the store numbers in the first column and the corresponding names in the second column. I need to do a vlookup formula in the first worksheet in the second column to get the names listed in the second worksheet to match up to the store numbers I have listed in the first worksheet in column one. I put in my formula =vlookup(A2,dealers!A1-B12,2,false) just like the videos all showed me and it always comes back as N/A. The a2 is from the first workbook in the first column where I selected the store number, I went to my second worksheet titled dealers and selected the whole table showing the list of store numbers and names. The names are in the second column so that is why I put 2 and then false for an exact match. This is exactly how they do it on the help videos and it works for them but not for me. I tried troubleshooting videos and I have made sure they are all formatted the same, there is no missing columns or rows, all the dealer numbers are the exact same, formatted the same and no spaces or anything. Is there something I am missing? Thanks.

2 Replies

    • KellyZachari's avatar
      KellyZachari
      Copper Contributor
      Thank you, I just tried that but it is saying N/A as well. I appreciate you taking time to try and assist me.

Resources