• 100% Satisfaction Guarantee
Jason Jones, Computer Expert
Category: Computer
Satisfied Customers: 17343
Experience:  Over 10 years of professional experience.
30759776
Jason Jones is online now

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

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

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 :

Jason :

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 :

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.