Get instant live Excel expert help with VLOOKUP formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Fix vlookup formula........................
Solved by M. C. in 14 mins
I need help making a if vlookup formula that displays the top scorer of a specific column
Solved by D. Y. in 17 mins
I'm writing a vlookup that is supposed to check for a single value across multiple worksheets and return the information I specified. I already got it to work for references to multiple sheets within the workbook by specifying those sheets in the named range, SheetList. However, what I need it to do is look at multiple separate workbooks instead of multiple separate sheets within the same workbook. I know I can get it to work if I just put the workbook names in the named range that the formula uses, but I can't figure out what conventions or syntax to use to name those workbooks.
Solved by C. Y. in 19 mins
I keep getting #N/A on Vlookup formula and I can't figure out the problem
Solved by I. S. in 15 mins
looking for formula that will tell me that cell value is repeating during vlookup
Solved by G. H. in 27 mins
Hello i want to fix my vlookup between sheets. Can you help me with that?
Solved by B. F. in 14 mins
I need to know if a formula can be written to pull information from one excel into another based off vlookup multiple columns. vlookup will not work but maybe an index and match formula can, I cannot get it to work and can upload the files
Solved by B. C. in 26 mins
need help to find out what is wrong with this formula
IF(AND(B11="20-29",D11="VO2max",E11="FEMALE"),VLOOKUP(F11,$R$78:$T$82,3,TRUE),""
Solved by F. F. in 13 mins
I want to copy the same formula for all the cells in Column G...M, this vlookup formula is working in cells G2...M2 for the selection made in list from column F.
It should be working same for all cells as per the product list in column A,
Solved by I. J. in 11 mins
Formula in cell B6 in "AP" sheet looks at # value in A6 in "AP" sheet. This value is looked for in column I in "Data" sheet. Once value is found in "Data" sheet column I it must look at the cell left of it (same row) in column H and return the text that will be within the same row in column J in "Data" sheet only if the value "3" is true in column H. If cell value is not "3" in column H, it skips that row in the "Data" sheet and keeps looking down column I within the "Data" sheet. I am thinking it would best to use VLOOKUP and IF / ONLY IF formulas to accomplish this. I have excel files I can send to help explain if needed.
Solved by Z. E. in 18 mins