All Questions
Tagged with worksheet-function vlookup
216
questions
0
votes
1
answer
23k
views
Apply VLOOKUP formula to multiple sheets
How can I apply a VLOOKUP formula to multiple sheets in Excel 2010?
Our formula is written and it is working on our Sheet 1, but we need to search 3 Sheets (within the same Workbook), preferably ...
1
vote
1
answer
534
views
In Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself?
Simple question and more than likely a simple answer.
I have a workbook with a few worksheets, one of which is a 'data' worksheet. This information is utilized on another worksheet 'main' to fill in ...
0
votes
2
answers
376
views
Can an array input be used in the sheet name of vlookup's range?
I have a formula which works, but is absurdly long, but repeats the core data over and over.
My spreadsheet contains 70 pages describing sets of cards. The page I'm working on gives me a particular ...
1
vote
1
answer
9k
views
Excel IF and VLOOKUP function help
The exercise is to use IF() and VLOOKUP() functions to return the tax rate based on the annual income and number of people in the household.
So far I've tried inputting:
=IF(AND(B$2=3,C$2<=35000),...
0
votes
1
answer
247
views
Excel vlookup help
=IF(N101<>"",ROUND(VLOOKUP($N101,$I$30:$U$39,12,FALSE)/(1-(U$96+U$98)),0),0)
That is the current VLOOKUP in the spreadsheet that is returning the wrong data. I didn't write it, it was on a ...
0
votes
1
answer
528
views
When switching to another doc, Function Argument window disappears?
I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears.
Google finds some results about the ...