twilley259
New Member
- Joined
- Jan 24, 2019
- Messages
- 16
Hello,
I am needing help with a complex lookup formula. I have a table of data with information in it shown below.
[/URL][/IMG]
So on sheet 1. I have a drop down with all the work cells listed. Whenever I select the title from the drop down, I want a formula to find that title in Row 1 then look in that column for the X's I have placed. These X's show which work instructions pertain to that job. Any field with an X I want the formula to return the hyperlink in column A. I hope this makes sense. Basically, you make a selection, excel finds that title, then if there is an X in that column it returns the corresponding A value.
[/URL][/IMG]
I am needing help with a complex lookup formula. I have a table of data with information in it shown below.
![Table_zpserhog9hb.png](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22https%3A%2F%2Fs77.photobucket.com%2Fuser%2FAudiobahnaholic%2Fmedia%2FTable_zpserhog9hb.png.html%22%5D%5BIMG%5Dhttps%3A%2F%2Fi77.photobucket.com%2Falbums%2Fj62%2FAudiobahnaholic%2FTable_zpserhog9hb.png&hash=4b20be93a3caababfdd7992c4379294a)
So on sheet 1. I have a drop down with all the work cells listed. Whenever I select the title from the drop down, I want a formula to find that title in Row 1 then look in that column for the X's I have placed. These X's show which work instructions pertain to that job. Any field with an X I want the formula to return the hyperlink in column A. I hope this makes sense. Basically, you make a selection, excel finds that title, then if there is an X in that column it returns the corresponding A value.
![Data_zpslbgq0ds9.png](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fs77.photobucket.com%2Fuser%2FAudiobahnaholic%2Fmedia%2FData_zpslbgq0ds9.png.html%22%5D%5BIMG%5Dhttp%3A%2F%2Fi77.photobucket.com%2Falbums%2Fj62%2FAudiobahnaholic%2FData_zpslbgq0ds9.png&hash=6f676c37c15e2d1c59ff75b48b2ff4c1)