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

In cell H7, create a nested if formula that will give the same results as the previous vlookup formula. Copy and paste the formula down the rest of the database.

Solved by E. E. in 27 mins

Hello, I recently updated my version of excel and now when try to use a formula like Vlookup, it's not working

Solved by G. L. in 29 mins

Hi,
I need help with one formula. The argument is basically:-
If cell x = November, return "Nov-17", if cell x = December, return "Dec-17", if neither, return "cell x + "2018"
The value returned by the formula must then be able to used with a vlookup

Solved by D. U. in 20 mins

I need to amend a work sheet with 2 tabs, ineed to remove to columns on tab 1 and then amend a vlookup formula on tab 2 to reflect the deletion. Can you assist please?

Solved by C. Y. in 27 mins

Hello,
how do I create a an informational generator that will work based off typing in a code and the whole information relating to that code coming up on excel?
I believe it is something to do w/ Vlookup?
I am really struggling with the formula bit though
Thank you in advance

Solved by E. F. in 12 mins

I need help with my formula to do a vlookup in excel step by step

Solved by V. A. in 29 mins

I need a formula to return data in distinct rows that all start with the same value. I am doing a vlookup to find a matching value and returning columns after that initail match. However, column 1 has many duplicate values but the values in columns 2,3,4,5,etc. are different even when the value in the first column is similar.

Solved by A. B. in 28 mins

I need help with my vlookup formula to took across different worksheets.

Solved by M. E. in 13 mins

Having trouble with a VLOOKUP formula. My reference cells have different values in them (from 1 to 6 comma separated values). I keep getting a REF or N/A error...

Solved by F. C. in 17 mins

Need formula to determine the appropriate answer from at least one chart when multiple conditions are met. I've been trying IF and vlookup formula's, but have not had success yet. please help.

Solved by B. J. in 30 mins