Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EXCEL FORMULA PROBLEM
I CAN NOT GET A FORMULA TO WORK CONSISTANTLY
=VLOOKUP(B7,Q:R,2,FALSE) I AM LOOKING TO HAVE THREE COLUMNS OF SCORES R-S-T A LIST OF TITLES IN COLUMN Q, AND THREE SEPERATE LISTS OF ITEMS AND SCORES IN COLUMNS B,C,D,E,F,G, IF YOU CAN HELP I CAN E-MAIL A COPY OF MY DOCUMENT FOR CLARIFICATION THANKS |
#2
|
|||
|
|||
Please do not type in capitals it is hard to read. The best explanation
of why it is hard to read is that we look at pattern of the letters rather than reading individual characters. Capital letters are also used for shouting, which of course would be rude, which is ineffective when asking a question. I think you have to put in a definite range for your table. =VLOOKUP(B7,Q$2:R$400,2, False) If you are looking for the exact value of cell B7, in column Q you would be returning the value in the same row from Column R. http://www.mvps.org/dmcritchie/excel/vlookup.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "detlghtpd" wrote in message ... I CAN NOT GET A FORMULA TO WORK CONSISTANTLY =VLOOKUP(B7,Q:R,2,FALSE) I AM LOOKING TO HAVE THREE COLUMNS OF SCORES R-S-T A LIST OF TITLES IN COLUMN Q, AND THREE SEPERATE LISTS OF ITEMS AND SCORES IN COLUMNS B,C,D,E,F,G, IF YOU CAN HELP I CAN E-MAIL A COPY OF MY DOCUMENT FOR CLARIFICATION THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
How do I set up a formula in excel? | New Users to Excel | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Staring Excel Problem | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |