Forum Discussion
Excel formula/function help! Please
Hello! I have: 2 worksheets in same work book (worksheet Bill & worksheet Casey) each worksheet has Col A - client #s and Col D - status Here's what I need to do.... I hope someone can help. Ne...
The attached workbook has a simplified example with a VLOOKUP formula in Col D on Sheet "Bill". I just sorted Bill's list differently from Casey's to demonstrate that the order of Client#'s doesn't matter.
In Col E, i entered an example using INDEX/MATCH. Same result, different approach.
Is that what you need?