NewFocusConsult
asked on
Lookup Formula Required
Hello,
In Column A of my Spreadsheet I have a list of Account Numbers , each of these numbers is unique. In column B I have a Dept Code. In column D I again have Dept and in E I have State. I want to populate Column C with the right State which corresponds with the correct value by looking up the value in column E. I might not have made sense so have attached the excel spreadsheet.
Lookup-Example.xlsx
In Column A of my Spreadsheet I have a list of Account Numbers , each of these numbers is unique. In column B I have a Dept Code. In column D I again have Dept and in E I have State. I want to populate Column C with the right State which corresponds with the correct value by looking up the value in column E. I might not have made sense so have attached the excel spreadsheet.
Lookup-Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@LesterClayton,
look for cell C12, there is no correspondent value in col E.
look for cell C12, there is no correspondent value in col E.
Indeed, I was about to edit my post to say "Use Ryan Chong's" solution instead - it takes into account no values found. :) But I can't edit once somebody else makes a post.
@NewFocusConsult - use Ryan Chong's answer.
@NewFocusConsult - use Ryan Chong's answer.
ASKER
Thanks
@LesterClayton,
no worries I just want to highlight the error cell cheers.
no worries I just want to highlight the error cell cheers.
Open in new window
Results:
I've attached your same Excel spreadsheet with the formula included on each line :)
Lookup-Solution.xlsx