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

Hi, I have problem with formula MATCH and reference cell. I have created a column of range values, for example like this: Z1=A1:A10, Z2=B1:B10, Z3=C1:C10...
I first use VLOOKUP to find the cell with range I need and that I use the result in MATCH formula instead of range - cell reference to the range. I get N/A error. I think the problem is that Vlookup returns "range" value as text. I tried multiple ways to change it to general or number data type but nothing works. Also I tried to go around and use combination of index and match to come to the same result but it returns the same N/A value. I am out of options how to fix it. Any advice?

Solved by Z. Y. in 21 mins

I have a pretty complicated formula that I am trying to work out. I assume I need to use IF & VLOOKUP in the one formula to make this work, but I cannot get it to work how I want it to and I am not even sure it can happen.
So I want to type a Team Name into say call A2 (Finals 1 sheet), down below I have Players Numbers & Players Name A5:B15. I have a "Players List" sheet that already have the completed names & numbers in it.
Is there a way that I can type the team name into A2 and it automatically populates the player numbers & names into the cells below?

Solved by X. Q. in 19 mins

Hi
I have a VLOOKUP / SUMPRODUCT formula I need to get working. It used to work before but some one interfered with it and now it does not. I usually can rectify but for some reason, I cannot this time.
Cheers

Solved by B. Y. in 30 mins

I have a complex vlookup formula that is now working

Solved by I. S. in 12 mins

I need to enter a VLOOKUP formula between two sheets.

Solved by F. J. in 24 mins

I have a vlookup formula but it seems that excel is not recognizing the lookup value in the cell.
I already checked that the formula is correct, and the formatting is not text.
Any other reasons why it isn't recognizing the cell value?

Solved by S. B. in 12 mins

I'm using a simple IF formula that won't return the correct results because it's pulling from a cell that has a VLOOKUP formula in it. It's not recognizing it as a number.

Solved by E. F. in 23 mins

Hi, I have an excel project where I am trying to use Vlookup. I have two columns with names. The 2nd column has a list of members, so I need help on how to compare two columns in excel to fin difference so that I can find out who are members and who are not). I have tried a number of formulas and tried a module but can't seem to make it work. Thanks!

Solved by M. U. in 27 mins

I UPLOADED A FILE WHERE THERE ARE 2 SHEETS:SHEET 1 I EDIT ANYTHING I WANT AND IN SHEET 2 I ACCESS THEM. IN SHEET 2 THERE IS "ENTER ID HERE".WHAT I WANT TO DO IS TO ENTER THE ID OF THE STUDENT AND ALL THE OTHERS(NAME,EXAM 1,2, FINAL EXAM, ATTENDANCE,PROJECT,GRADE,LETTER,CONCLUSION) WILL APPEAR AS SOON I ENTER THE ID.HOW TO DO IT USING BOTH INDEX-MATCH FORMULA AND VLOOKUP: THANK YOU

Solved by I. U. in 19 mins

Hello, I am trying to create a csv generator which will look up all the information from background speadsheets and bring it up in the necessary fields. I am not sure why but when I change the column index number (where the pricing info is), it does not want to work, can anyone help please?
My formula is below:
To look up Description
=IF(LEN(E16)<1,IF(LEN(G16)<1,"",VLOOKUP(G16,MATCODE1,2,FALSE)),"")
To look up Price
=IF(LEN(G16)<1,IF(LEN(J16)<1,"",VLOOKUP(J16,MATCODE1,5,FALSE)),"")

Solved by I. D. in 27 mins