Referencing Next Column Over

Thanks, that works for K4, but I actually need it to "scan" the whole K column for whereever the "F4" Value is (it will not be in the same ROW from day to day, but it will be in the "K" Column)

Then report the name next to that Value (i.e. "PER1, PER2, PER3, etc) and put that name into E-5.


The K column is where I will be picking a value "F4, IN, etc" from a drop down menu, one day the F4 Value may be next to "PER1" the next day, Maybe "PER4 or PER5"


Thank you once again


Nate

That works great.. Thanks

One minor problem is that when I try and copy my K Values from a Different Spread sheet it screws it up. I've attached an Updated Example.

Try Copying over the K Values to the K column on the new spread sheet I attached.


Thanks
Nate

I'm still trying to work around the issue, but it seems to not like when i copy/paste, Maybe because I'm not really typing the letters "F4" into a certain block.

Any Ideas?


Nate