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: 16054
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 and other Computer Specialists are ready to help you