Excel lookup value and return another value

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 !
LVL 3
fjkaykr11Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Wilder1626Connect With a Mentor Commented:
here you go

=IF(A1="Car","Car",0)
Excel1-updated2.xls
0
 
Wilder1626Commented:
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
 
fjkaykr11Author Commented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Wilder1626Commented:
i don't see your file. Can you attach the file again please?
0
 
fjkaykr11Author Commented:
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
 
Wilder1626Commented:
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
 
fjkaykr11Author Commented:
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
 
fjkaykr11Author Commented:
Thanks! I had tried this already but forgot the quotes.
0
 
fjkaykr11Author Commented:
thanks a lot
0
 
Wilder1626Commented:
i'm glad i was able to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.