I'm trying to figure out how to find text within a column that matches a cell content, and if matches then populate the contents of another cell.
For example on the attached file:
I want to do a search for contents of C5 on all cells of column E, if it matches the query then populate B5 with contents of cell D504 (HW-01-00114)
Last edited by DRkidd22; 01-21-2022 at 08:45 PM.
C2, copied down:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks