Solved

Excel lookup value and return another value

Posted on 2015-01-24
10
112 Views
Last Modified: 2015-01-24
In Excel how can I look through a range of values in column A and if a match is found return that value in column B.  I attached a sample Excel file.
In the sample file I need to search column A and return when a match is found for
the value = Car in Column B.  Thanks for any help !
0
Comment
Question by:fjkaykr11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40568552
Here is an example in the attachment:
=VLOOKUP(F1,A:B,2,FALSE)

The formula is in G1

FYI, i did not see any temple from you.
vlookup.xlsx
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 40568553
at wilder1626 thanks for the reply, I am having trouble following the sample file you provided (sorry). Can you view the sample file I uploaded?  I was hoping someone could edit the sample I provided it might be easier for me to follow.
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40568557
i don't see your file. Can you attach the file again please?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Author Comment

by:fjkaykr11
ID: 40568565
Here is the sample file.  I was hoping to be able to do this with just the one column of data, as in the sample. Thanks again.
Excel1.xls
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40568567
Here you go.

I just dont understand why this VLookup is needed. Can you explain more?

But have a look at it first
Excel1.xls
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 40568570
Attached is an updated file of what I was hoping to get back in Column B.
Its just a sample file, I realize I can do this with a filter or sort. but I have a LONG list of items with much longer names. I want to get the basic idea and then build on it.
Excel1-updated.xls
0
 
LVL 11

Accepted Solution

by:
Wilder1626 earned 500 total points
ID: 40568573
here you go

=IF(A1="Car","Car",0)
Excel1-updated2.xls
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 40568585
Thanks! I had tried this already but forgot the quotes.
0
 
LVL 3

Author Closing Comment

by:fjkaykr11
ID: 40568587
thanks a lot
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40568590
i'm glad i was able to help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question