“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

write a formula, i need vlookup to return a text and now a number

Solved by K. C. in 25 mins

Hi. i have data
but from this data, i need to find the accounts that have done deposits
and put them on another list
and i want to make a formula with vlookup or some other function
where i can just paste the data in the spreadsheet
and the formula will automatically lookup which transactions or accounts have deposits
and pull that data onto another list
and ignore the rest of the daya
*data

Solved by G. Q. in 16 mins

I'm receiving an error, "#N/A" with my VLOOKUP Formula. I'm simply trying to find if the same transaction number found in Column I, in the Payments sheet, is also located in the Transaction Number in Column D on the Transactions Sheet.

Solved by I. U. in 14 mins

Hi, i'm trying to do a vlookup up formula in column N, this looks to match the values in column L with the values in column B and return the value from column E.
The data in columns A:F is updated with a macro. The data in J:N is used in a report.
I know what the problem is, that the date and time in column B has an extra space between the date and time, hence why the vlookup wont work. But i dont know how to solve this?
The data that the macro takes from another worksheet does not have this extra space in it.

Solved by K. D. in 17 mins

i need somebody who can understand client. looking for formula to have a mapping aligned either by vlookup and formula.

Solved by D. W. in 11 mins

need help with vlookup formula , having more than two conditions to search and get the value from another sheet.

Solved by E. B. in 30 mins

I have a question about Excel. I need to create a formula similar to standard Vlookup, but instead of one look up value I need to have two of them and in different columns.

Solved by X. B. in 13 mins

I need help editing the following formula. =IF(VLOOKUP(I16,Transactions!$D:$J,1,0)=I16,"FALSE","TRUE")
The formula should compare Column I on the "Payments" sheet and Column D on the "Transactions" sheet and return the value from Column I if the value is NOT included on the Transactions sheet.

Solved by A. W. in 20 mins

I have three steps I must do which involves me dealing with vlookups and no matter what I look up, I am still confused and can't get my formula to work. I need help please! step 1: Switch to the worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country.

Solved by D. E. in 15 mins

I have a spreadsheet with over 250,000 records about heating and insulation, The headings are - Measure Category, Measure Type, Property Type, Pre Main Heating Source, Post Main Heating Source, Name Of Uplift, Uplift, Average POPT Factor, Cost Score and Annual Saving. I want to use a formula where you type criteria in measure type to average popt factor and it comes up with the cost score and price. I have tried if statements and Vlookup etc but have gotten nowhere, Please Help.

Solved by O. U. in 19 mins