jsuvman58
New Member
- Joined
- Jan 14, 2012
- Messages
- 17
I have a pivot table that can not be changed. I am using VLOOKUP on another sheet to create a different form. Is there a way to get data from the “Left” of the value that the VLOOKUP formula finds? </SPAN>
Here is a example I created. Let’s say VLOOKUP is using the “Employee ID” as its reference. How do I get it to return the “Department”? It would be nice if you could just tell it minus one (-1) and it would work. </SPAN>
I know it can be done with a macro but was wondering if there was an easier way? Maybe with the INDEX or MATCH function? I am not that familiar with these. </SPAN>
=VLOOKUP(34, B2:D5, 3, FALSE) – This would return the address of Jim Kim as you know. </SPAN>
<TBODY>
</TBODY></SPAN>
Here is a example I created. Let’s say VLOOKUP is using the “Employee ID” as its reference. How do I get it to return the “Department”? It would be nice if you could just tell it minus one (-1) and it would work. </SPAN>
I know it can be done with a macro but was wondering if there was an easier way? Maybe with the INDEX or MATCH function? I am not that familiar with these. </SPAN>
=VLOOKUP(34, B2:D5, 3, FALSE) – This would return the address of Jim Kim as you know. </SPAN>
Department</SPAN> | Employee ID</SPAN> | Name</SPAN> | Address</SPAN> |
Sales</SPAN> | 34</SPAN> | Jim Kim</SPAN> | Anywhere</SPAN> |
Production</SPAN> | 45</SPAN> | John Doe</SPAN> | Anywhere</SPAN> |
Accounting</SPAN> | 32</SPAN> | Jane Hatty</SPAN> | Anywhere</SPAN> |
Operations</SPAN> | 67</SPAN> | Joe Turner</SPAN> | Anywhere</SPAN> |
<TBODY>
</TBODY>