Star Gazr1
asked on
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 !
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 !
ASKER
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.
i don't see your file. Can you attach the file again please?
ASKER
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
Excel1.xls
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
I just dont understand why this VLookup is needed. Can you explain more?
But have a look at it first
Excel1.xls
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! I had tried this already but forgot the quotes.
ASKER
thanks a lot
i'm glad i was able to help
=VLOOKUP(F1,A:B,2,FALSE)
The formula is in G1
FYI, i did not see any temple from you.
vlookup.xlsx