need help to search a column, find a letter, and return the number at the top of the row, the letter appears in.
for example, i do schedules.. say. 50 people, my form…
I want it to search the row next to employee. When it finds a " B ".
Input the time at the top of the column.
trying to add an attachment.. but not sure it worked here.
hope this is clear
THX
sorry, not very clear, and no attachment came through
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ok, for some reason nothing is being attached in here.... so i did copy paste... the top row are times.... the rows below are schedules in 15 min intervals.. i want it to search a row, look for a " B ", the call up the time in the top row... EG. the first 9, time is 9:45... hope thats more clear??
9:30 9:45 10:00 10:15 10:30 10:45 11:00 11:15 11:30
1 B 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 B
ok, i managed to attach a file... thanks
To find the first "B" in A3:Z3 and return the corresponding value from A1:Z1 try this formula
=INDEX(A$1:Z$1,MATCH("B",A3:Z3,0))
adjust ranges as required and copy down for subsequent rows
Audere est facere
humm, no, that doesnt seem to work.... so it needs to search along row 4, when it finds a " B ", it calls up the time in the top of the column " 9:00 "
Clearly you can do the same with row 4 - did you try this version?
=INDEX(A$1:Z$1,MATCH("B",A4:Z4,0))
That finds the first "B" in A4:Z4 and returns the corresponding value from row 1
yes, that actually seemed to work, thanks alot..... when I coppied it down though, i had a few " #N/A " pop up? any idea why?
ok, I think i figure out how this is working now... thanks alot... that was a big help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks