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?
 
Wilder1626Commented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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.