All Questions
9
questions
0
votes
1
answer
99
views
How to convert a simple VLOOKUP to XLOOKUP in Excel?
The VLOOKUP works as intended. The XLOOKUP is giving "#NAME" error:
screenshot of the formula:
the working VLOOKUP:
=VLOOKUP(C12,B24:C29,2,FALSE)
Which I'm reading as "take the ...
1
vote
1
answer
5k
views
VLOOKUP and HLOOKUP combo
I am struggling with the following (see snapshot) and I can't understand what I'm missing.
If the id matches, I would like to extract the value of that id in when the values in col2 matches the ...
1
vote
1
answer
92
views
Excel - How do I look up multiple cells from a single reference?
I'm looking to somehow look up a certain amount of cells from a single reference and return them in the same order in another workbook.
For example, say I have 5 different SKU codes (these aren't ...
1
vote
1
answer
101
views
Values in a column to rows based on multiple criteria
I am trying to turn a the table on the left side to the one on the right.
How can it be achieved? I have tried This, but it did not work.
0
votes
1
answer
1k
views
Need formula to calculate tiered commissions, according to percentages
First off, I have looked everywhere, and every solution assumes that I'm working with dollar amounts, but my client works with percentages. That being said, I need to figure out the formula to ...
0
votes
1
answer
63
views
Excel 2013 - How to have a Lookup return the first date after a specified date?
So I am looking to create a function that searches for a unique ID code in one column, and returns a corresponding time stamp from another column. However, there are multiple time stamps attached to ...
0
votes
2
answers
1k
views
How to make excel SUMUP values of multiple rowkeys in a two-dimensional lookup to return sumed up values in a corresponding cell
So I have this challenge with a set of data arrangement and by merging the VLOOKUP and MATCH strings I was able to get my result but there is a little hiccup!
Pasted below is the merged string that ...
0
votes
1
answer
47
views
in ms excel, is there a way to look up an array and edit data on the looked up row?
Just for a quick example, I have this table:
A B
1 student grade
2 john 90
3 paul 93
4 peter 87
5 bill 84
6
7
Range or array is A2:B5.
I want ...
0
votes
3
answers
981
views
Excel multi table lookup, can you find a more elegant solution?
This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...