Hello All
Not sure if this is possible. I am thinking an index and match, but unsure
I would like to insert the # found in column C into the Corresponding General procedures( columns D thru Q ) by matching Column B with Column S . The # should be placed into matching column based on table in columns S and T.
Sorry, this maybe confusing, so I tried to color code what I am trying to do as well
Try
in D2
=IFERROR(IF(VLOOKUP($B2,$S$2:$T$19,2,0)=D$1,$C2,""),"")
Copy across and down
Notice change to headings (LOS removed)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Some of your headings D1:Q1 have double spaces which makes things harder. I changed all double spaces to single. Similar some entries in column T had trailing spaces, which I removed.
The rows with errors have no matching procedure in column S.
This formula in D2 and copy/paste to fill table:
Formula:
Please Login or Register to view this content.
It turns out that you were correct that this can be done with INDEX/MATCH but it's better to describe your problem instead of assuming what the solution is.
Thank you so very much John ! Greatly appreciated
Thank you very much Jeff ! I am grateful !
Happy Thanksgiving
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks