I am new to excel, i would like to know if i need a formula to lookup a value in a 2 ways table, how can i do it.
I am attaching my file into this for clearer picture. Thanks
I am new to excel, i would like to know if i need a formula to lookup a value in a 2 ways table, how can i do it.
I am attaching my file into this for clearer picture. Thanks
Whis is 31 and 32 in Feb?
huh...that was supposed to be the week number but i did not change it to the correct order. Just an example..
My guess is that he auto filled the row
Peace of mind is found in some of the strangest places.
evlai,
You apparently copied and pasted from a PivotTable, which is already summarizing the data for you. I honestly do not understand what you are trying to do.
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
A general answer to your question would be the help file on the following formulas:
LOOKUP
HLOOKUP
VLOOKUP
INDEX
MATCH
Note however, that you can not specifically lookup a value in a table two ways, or two times in one formula without some added complexity.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Hi All,
I understand it will need very complex formula if i want excel to perform this for me. I have actually tried many times to figure out the solution, but yet to find one.
Patrick was right, the data is actually performed by pivot, but i need this because of i have many worksheets with this summarized calculation. I need to summarized some of the special group into a Summary worksheet only. i need to check the data every time when i want to updata the data into the Summary worksheet and it is really time consuming for me to check more than 10 worksheets and ensure the columns/ rows are in correct order. That is why i was thinking to have a vba/formula to automate my report.
Evlai
Hi Evlai,
I can't understand your requirements. Can you add some comments/textboxes to your sample to show what is needed and where.
Data such as Jan, Feb, Aug really doesn't help. Without clarity on your part, it's vey confusing here.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
If your intent is to have a lookup formula find and evaluate data on 10 different sheets, this will not only be a complex formula, but it would take forever to calculate (that is, if one could be written to do this in the first place).
If the data were all set up the same you can possibly set up a formula to get that cells information from each sheet which would not be too tough..
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!