Avatar of grindsmygeaqrs
 asked on

Excel V-Lookup (match field value and import specified field)


Experts, please help! I have the following columns, A B C D.

I need the values in column A to be checked against the values from column C. There will be multiple values in column C that match the single value in column A. Whenever there is a match I need the value in column B that is in the adjacent the matched value/call in column A to be imported into column D, adjacent to all of the matched values in column C.

Is this possible? Thank you for your time.
Microsoft ExcelMicrosoft OfficeProgramming

Avatar of undefined
Last Comment

8/22/2022 - Mon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Hi byundt. Thank you and I'm sorry for the late reply. The formula isn't working. It returns the same 5 digit value in ever cell in D column. The value is not located anywhere in B.

I didn't make this clear but the values in A and C do not match exactly down the columns. They are out of order.

Please post a sample workbook that demonstrates the problem.

The formula is working as I expect at my end, so I am thinking there may be something special about the type of data in your actual workbook. For example, text that looks like numbers will cause problems with a VLOOKUP formula--but there are workarounds.

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy

I am so sorry I had a health issue and was not able to respond the past several weeks. The function is working correctly.. formatting was the issue. Thank you do much!