All Questions
8
questions
2
votes
2
answers
87k
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 ...
0
votes
2
answers
3k
views
VLOOKUP with multiple criteria
I have a workbook with 2 sheets: spg and data
From the data sheet I wish to do a vlookup in the spg sheet, based on the value of multiple columns in spg.
I can do a =VLOOKUP(H5,spg!$D:$I,6,0) but ...
1
vote
1
answer
5k
views
Lookup list dependant on the contents of another cell
hope someone can help to crack this one?
I've got a table on my data entry tab (sheet 1) where each row includes two data validation drop down lists (source is on sheet2). I want the options in the ...
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
1
vote
1
answer
943
views
How do I use Excel's VLOOKUP function?
I want to use Microsoft Excel's VLOOKUP function to find data in my spreadsheet. I've tried looking at online guides, but I'm still confused as to how the function actually works.
How do I use the ...
1
vote
1
answer
197
views
VLOOKUP logic when range_lookup is TRUE but table_array is not sorted
Excel's VLOOKUP hint tells us to use range_lookup = TRUE only when the table_array is sorted. However, does anyone know what is the logic that VLOOKUP executes when range_lookup = TRUE but table_array ...
0
votes
3
answers
23k
views
How to return all the cells in a row if first column matches a value on another worksheet
I have 2 worksheet tabs in an Excel workbook, tickets and tickets info. I have values in Column A of tickets (from A2:A500). I want to search for each value from A2 to A500 of the ticket sheet looking ...
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 ...