lookup dropdown

Hi Guys, I am trying to wrap my head around the HLOOKUP function or which ever one is the best. I need to have an answer cell lookup a value from a drop down menu as below: <tbody> Price Product PPN HD </tbody> That will be on one sheet. "Product" has a drop down menu for the...

I am trying to use the lookup function in excel. In Cell M1 I have a drop down list of all the months of the year with just using the first three letters of the month. In cell M2 I have the following lookup statement...

Hi, I have put together a spreadsheet that shows all the holidays booked for the people in my department with each month on a separate tab. I am also in the process of creating a central shared spreadsheet where anyone can go in and have access to this information, I would like to know if there...

Hey Guys, I have a database where In column A I have a data validation dropdown with 4 options "List 1, List 2, List 3 & List 4". I then also have in Columns F,G,H & I The titles in Row 1 of "List 1, List 2, List 3 & List 4" and in 4 rows below each title 4 different fixed values under each...