Forum Discussion

kamjam's avatar
kamjam
Copper Contributor
Mar 28, 2018
Solved

excel help needed

Hi. I don't really use excel at work...until now.  I have been given task and I am stuck.it will take me ages to do it manually, I thought you guys could help me to create formula. so the 1st spreads...
Formulas & Functions
training
  • Jamil's avatar
    Jamil
    Mar 29, 2018
    It is obvious that your lookup value is number but stored as text and the data where you are looking for values are numbers stored as number.

    so either you need to change the lookup values back to numbers or simply you can revise your formula like this =VLOOKUP(VALUE(B2),................................... rest of reference

    simply wrapping B2 with VALUE(B2) will solve it. Also in your formula you are using entire column reference like A:B which slows down your workbook. It is important to use Excel Tables, or only select the ranges with data instead of whole column reference.
kamjam's avatar
kamjam
Copper Contributor
Mar 29, 2018

Hi Jamil

 

the problem is I don't how to create v lookup formula . 

Jamil's avatar
Jamil
Bronze Contributor
Mar 29, 2018
You can lead VLOOKUP from my friend’s youtube channel. The first 8 minutes explains the basic of vlookup.


https://youtu.be/-hJxIMBbmZY

Resources