if function & v lookup

hello Im trying to build a data base of parts warranty info. what im looking to do is when I select a part number via drop down menu in the 'part number' column, the corresponding description and cost columns in the same sheet are automatically filled in. my image below... the PN# column is a...

Hi, I need help on how to formulate excel formula on this file. I need to get the exact rate per ton of specific employee based on their Ranking and Type.

Hi Everyone, I've been trying to get a vlookup formula to work but just realised that vlookup only looks up the first occurrence of a match. How do I make an if function which returns a value if ANY occurrence of a match meets the criteria? i.e. My raw data looks like this: Site ID Name...

I have data in multiple excel sheets in the same workbook. All sheets have the same table but different data as each sheet represents a certain date. The name of shops in the table are chosen from a dropdown list and you can see the full list of shops to the right of the photo. What i want to do...

Hi, I am having a problem writing a nested IF with a VLOOKUP. I have Columns D to O as my table array, with a text string in Col D of which I need to look up "leisure" "business" or "personal". I then need the result of the formula to put which ever of these text options that appear in the...

Is it possible to add an IF function to TEXTJOIN? I would like to make it so if any number in column 5 in the first VLOOKUP is more than 95 then it gives the message "BP". Can this be done? Here is the formula: =TEXTJOIN("x",,VLOOKUP(A3,FOLDED!$A$2:$I$7,5),VLOOKUP(A3,FOLDED!$A$2:$I$7,6))...

Hi everyone! I've only recently started using if functions so I need some help with my situation. Say I have a spreadsheet with a list of employees and their salaries. Each employee belongs to a group each with their min and max pay. So what I need to do is to use a formula to see if the salary...

Hi I have 2 list's of Data. I want to run a vlookup formula on one data sheet with another. If the Data is contained in the 2nd table I want to return the narrative "in stock". If it is not included in the other table I want to run the narrative "not in stock". What formula would I use?