• 100% Satisfaction Guarantee

Jason Jones, Computer Expert
Category: Computer
Satisfied Customers: 14688
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

### 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 :

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.

Jason Jones, Computer Expert
Category: Computer
Satisfied Customers: 14688
Experience: Over 10 years of professional experience.

### 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.

• ### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### James K.

#### Satisfied Customers:

93
Technical Director of IT Company

### Jon-Tech

#### Satisfied Customers:

61
20 yrs: Computers, Networking

### MikeW

#### Satisfied Customers:

53
32+ years Computer and Networking Experience

### jamieratliff

#### Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

### TheDoctor

#### Satisfied Customers:

16
Experienced Software Engineer

### Bill Fisher

#### Satisfied Customers:

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