How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jason Jones Your Own Question

Jason Jones
Jason Jones, Computer Expert
Category: Computer
Satisfied Customers: 14688
Experience:  Over 10 years of professional experience.
30759776
Type Your Computer Question Here...
Jason Jones is online now

Hi there - am trying to get a formula that looks at a column

Resolved Question:

Hi there - am trying to get a formula that looks at a column of data to see if there is a matching number and if there is then it returns a value in the column next door
Submitted: 3 years ago.
Category: Computer
Expert:  Jason Jones replied 3 years ago.

Jason :


Hello and thank you for your question today. My name is Jason. I look forward to helping you today.


Jason :

This can be done very easily with the VLOOKUP function.

Jason :

In this example, I will assume that Column A has the numbers you wish to match and Column B is the value that you wish to return.

Jason :

Hello

Customer:

I have been trying to get it to work and not having any luck

Customer:

OK - go for it

Jason :

Here is the formula:
=VLOOKUP("Value",A1:B10,2,FALSE)

Jason :

What that formula will do is look for the value "Value" in the table A1:B10

Jason :

When it finds the value, it will return the value in the 2nd column, which is the B column in this case.

Jason :

Does that make sense?

Jason :

You would replace "Value" with the value you are looking for, replace A1:B10 with your table values.

Jason :

Also, you could replace "Value" with a cell reference.

Customer:

this is the formula i have tried - =VLOOKUP(AF2,Vital,15,FALSE) and I have asked it to look at the number in cell af2, check it in the table I have called Vital, then return the figure that is in the 15th column but only if it is an exact match?








#/A
Customer:

does that make sense?

Jason :

Yes

Jason :

That is the correct formula for such.

Customer:

well it keep giving me "n/a"!

Jason :



Thank you for the update.

May I please, start a remote screen sharing session with you so that I can better help you resolve this problem? No extra charge.

Customer:

absolutely!

Jason :



Thank you.

Please, click the following link and allow the remote app to run: http://166.78.231.170:8040/?Session=42c429cb-84cf-4a66-9ea8-e0877c389dea

Jason :

Please, allow all to run.

Jason :

Thank you for your time.

Jason :

Here is the end formula that works for the first row:
=IF(OR(ISNA(VLOOKUP(VALUE(AF2),$H$2:$R$26232,11,FALSE)),NOT(ISNUMBER(VALUE(AF2))))," ",VLOOKUP(VALUE(AF2),$H$2:$R$26232,11,FALSE))

Jason :


I look forward to your next message or your rating below.

To rate me, you can click one of the faces below and click Submit/Ok or click the Accept button.

If you ever wish to work with me in the future, you can ask your new questions and have them sent to me directly at the following page: http://www.justanswer.com/computer/expert-computertechmaster/

Thank you again,
- Jason

Jason :

You can book mark the link above, if you wish.

Jason :

Thank you again.

Jason Jones, Computer Expert
Category: Computer
Satisfied Customers: 14688
Experience: Over 10 years of professional experience.
Jason Jones and 5 other Computer Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    151
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    151
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.com/uploads/MI/mikew4950/2011-12-26_1606_mikephoto2s.64x64.jpg MikeW's Avatar

    MikeW

    Computer Engineer

    Satisfied Customers:

    53
    32+ years Computer and Networking Experience
  • http://ww2.justanswer.com/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.com/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.