[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 129
  • Last Modified:

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 !
0
fjkaykr11
Asked:
fjkaykr11
  • 5
  • 5
1 Solution
 
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
 
Wilder1626Commented:
i don't see your file. Can you attach the file again please?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
 
Wilder1626Commented:
here you go

=IF(A1="Car","Car",0)
Excel1-updated2.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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now