Lookup based on Cell Criteria

Originally Posted by nicci113

Richard, Thanks for the help.. I'm not sure why it came up as 2003, im on office 365 so the latest, I know how to use the slicer, but the requestor insisted on some format, which made me use formula only..

Hi,

Your profile is showing Excel 2003. To avoid any confusion in the future it would be a good idea to change it.