LinkBack URL
About LinkBacks
Good Afternoon
Attached is a copy of a spreadsheet that im working on, im trying to sort staff on their correct locations depending where i originaly select them.
The attachement will have more info
Help with this will be appreciated
Good Afternoon
Attached is a copy of a spreadsheet that im working on, im trying to sort staff on their correct locations depending where i originaly select them.
The attachement will have more info
Help with this will be appreciated
Hi. This might do what you want...
Paste into H4 & copy down...
Formula:
=IF(ISNUMBER(MATCH(C4,E5:E27,0)),C4,"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Glen
Thank you for your helpOriginally Posted by Glenn Kennedy
Hi. This might do what you want...
Paste into H4 & copy down...
Formula:=IF(ISNUMBER(MATCH(C4,E5:E27,0)),C4,"")
for some reason this formula isnt working for all the cells, i have copy and draged down but you will see that this only works if the cells are one or two rows above or below the target??
just add $ sign and it is working fine thanks you
I forgo to lock the cells in column E. When you use this on your real sheet, you'll need to re-set the ranges appropriately at the top of the column, before you copy down.
Yea, you beat me to the explanation...
You're welcome...
If that fixes things, please mark the thread as closed and (preferably) click the Add Reputation button at the bottom left of this post.
Ooops.
Try this...
Formula:=IF(ISNUMBER(MATCH(C4,$E$5:$E$27,0)),C4,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks