Tagged Questions

0
votes
1answer
51 views

vlookup and indirect and external shared workbooks

i have two excel workbooks that are both shared in our company folder. excel1 is where each employee has his own page to fill information and column 1 of each page is the row reference excel2 is a ...
0
votes
2answers
119 views

Looking-up the values of one worksheet in another worksheet

Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it. I have two worksheets in Excel. Worksheet 1. Column-A ...
1
vote
0answers
87 views

Excel: Why is VLOOKUP returning inconsistent and unexpected results?

I'm automating an Excel column to assign account values based on the vendor paid. For instance, if AT&T gets paid, the account value is Utilities:Telephone, and when the post office is paid, the ...
1
vote
4answers
63 views

Vlookup using wildcards in indexed column

I know how to use a wildcard with Vlookup on the reference value, but what about on the matched column index? I know you can do for instance VLOOKUP("*Hello*",A4:G4,2,FALSE) However, what if you ...
1
vote
2answers
116 views

Formula to merge column from sheetA to sheetB to matching ID

Match unique id Sheet1!A2 to a cell in Sheet2!A2:A100 that has the matching ID. Paste cell content from column Sheet2!C2:C100 from the same row with the matching id in Sheet2 to the cell with formula ...
0
votes
0answers
63 views

Search multiple worksheets, even when new ones are added

In Excel I'd like to search across multiple worksheets without having specifically to give the name of each one, so if I add a sheet it will look across that sheet too. I know how to look across ...
0
votes
1answer
6k 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 ...
0
votes
2answers
193 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
1answer
2k 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: ...
0
votes
1answer
125 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 ...