[ATTACH=CONFIG]63521[/ATTACH]
How can I use VLOOKUP to return fields that do not contain values in the columns to the left. Want to return only the yellow highlighted fields.
Thank you in advance for the much need help!
[ATTACH=CONFIG]63521[/ATTACH]
How can I use VLOOKUP to return fields that do not contain values in the columns to the left. Want to return only the yellow highlighted fields.
Thank you in advance for the much need help!
Re: Vlookup? Index? Match?
Hi excellearning, welcome to OzGrid
It's not very clear what you are asking, but basically you can't use VLOOKUP or INDEX/MATCH unless you have a unique value that you are looking up against. Perhaps if you could explain a little more about what you are trying to achieve we can offer an alternative solution?
Regards,
SO
Re: Vlookup? Index? Match?
Quote from S O;734783Hi excellearning, welcome to OzGrid
It's not very clear what you are asking, but basically you can't use VLOOKUP or INDEX/MATCH unless you have a unique value that you are looking up against. Perhaps if you could explain a little more about what you are trying to achieve we can offer an alternative solution?
Regards,
SO
Basically the report shows: SALES REPORTS FOR EMPLOYEES ( SOLD/TOTAL/%)
Col A Col B Col C Col D Col E Col F
REGION
EMP1
PROD1 3 3 100
PROD2 2 4 75
EMP2
PROD1 4 5 80
PROD2 3 3 100
I only want to find the values in Col F for each employee.
Re: Vlookup? Index? Match?
In your example image, would you be searching against "TECH1", "TECH2" etc... ?
Re: Vlookup? Index? Match?
Quote from S O;734791In your example image, would you be searching against "TECH1", "TECH2" etc... ?
Yes, that is correct. ie - L4HH results for each TECH. Many thanks!
Re: Vlookup? Index? Match?
Can you post your sample workbook? Click on "Go Advanced" button and then click on paperclip image button to attach your file
Re: Vlookup? Index? Match?
Try this:
Put the Employee number that you want to look against in K2
In M2, place this formula:
=INDEX(F:F,MATCH(K2,B:B,0)+2)
NOTE: I am assuming that the sample data you supplied in the image is a true reflection of your actual data and that it is laid out in the same way for each employee record.
Re: Vlookup? Index? Match?
Quote from azumi;734795Can you post your sample workbook? Click on "Go Advanced" button and then click on paperclip image button to attach your file
[ATTACH=CONFIG]63542[/ATTACH]
Re: Vlookup? Index? Match?
Quote from S O;734797Display MoreTry this:
Put the Employee number that you want to look against in K2
In M2, place this formula:
=INDEX(F:F,MATCH(K2,B:B,0)+2)
NOTE: I am assuming that the sample data you supplied in the image is a true reflection of your actual data and that it is laid out in the same way for each employee record.
This worked! THANK YOU SO MUCH!!
Re: Vlookup? Index? Match?
You're welcome
Don’t have an account yet? Register yourself now and be a part of our community!