Get instant live Excel expert VLOOKUP help

I need help with a formula, I have written one but need to add something else on and just can't seem to work it out? The formula in M9 is:=IF(OR(L9="No Date",L9="Enter Date Here!",L9="-"),"",SUM(L9,730)), What i'm asking is if any of the text is entered in cell L9 then cell M9 will be blank and just do the sum, however I now want to change it, if L9 says "No Date" then M9 displays "Not required". I have another formula in L9 already, which is:=If(ISNA(VLOOKUP(D9,Inputs!S:AE,9,false)),"-",VLOOKUP(D9,Inputs!S:AE,9,false)) this is carrying information across from another sheet. Help???

Hi I need help with a word problem that will include using VLOOKUP

Hello, I'm using the VLOOKUP formula and for some reason it's throwing a no value available error showing #N/A in the box. I know it's formatted correctly and it will pull a value when I double click on the lookup value, but It will not let me copy the formula down. I've made sure the comparison cells are formatted correctly before and after data entry so I'm not sure what's causing this error. Please help.

Dear Sir/Madam, Please help to create a formula. I want populate a table from drop down when select the table name. Please remember the table contain 5 column from 5 columns 2 columns contain drop down list and one column contain vlookup value. Best regards haider

Hello I need help for vlookup function to merge on ecloum to another worksheet

I need help to merge the files via vlookup tool

Hi, I'm looking to create a from by typing in the reg and it pulling through the data from the data tab. I've tried this as a VLookup but it only pulls through the first line and there may be more than one line under each reg for repair history. I tried doing this as a pivot table, but I don't like the layout of it and wanted to be able to type in a reg and it search for the data rather than filtering. I've tried a combination of both by creating a macro to copy the data from cell A1, refresh the data in the pivot table, filtering by pasting the results from A1 then copying the relevant data I require onto the form tab. It works, but when I change the reg it remembers the actual reg text from the macro rather than the act of copying and pasting the data in A1 from the form. Can you help me please? Is there anyway that I can do this?

hi, tried vlookup but not accurate - not sure if vlookup is the right way to go or something else situation - have two columns table (jobID and notes) - have one column table (jobID) want - compare the two jobID columns, if they are the same then in a blank column add notes against the one column table please help as this is needed promptly then more needs to be done thank you

I need help with VLOOKUP in order to complete a task for work ASAP.

Hi, I have two spread sheets, both with a column of customer names and a column of revenue, one being 2016 and one being 2017. As customers come and go, the list is not always in the same order. I need a function to place 2017 revenue in the cell next to 2016 revenue. I think it’s vlookup, but I do not have the skills. Can you help?