New answers tagged microsoft-excel-2013
0
votes
Too much arguments shown when used LOOKUP
Do you want to find the last value that meets the conditions?
In my opinion, your formula needs to follow the
syntax: =LOOKUP(1,0/(condition),(query area)), please try: =LOOKUP(1,0/(($B3=Master!$A:$A)*...
0
votes
Too much arguments shown when used LOOKUP
1,0 contains also a separator: ,.
Replace the it with a . or just remove it:
=LOOKUP(1/(($B3=Master!$A:$A)*(F$2=Master!$B:$B)),Master!$C:$C,"")
2
votes
How do I add new row in Excel *below* the current one?
I was looking for an answer and did not find a fast solution. So my recommendation is to use LibreCalc instead of Excel since there you always can insert rows above or below the current row and you ...
Top 50 recent answers are included
Related Tags
microsoft-excel-2013 × 1616microsoft-excel × 1115
worksheet-function × 427
microsoft-excel-2010 × 144
vba × 135
charts × 99
microsoft-excel-2016 × 72
pivot-table × 61
microsoft-excel-2007 × 53
conditional-formatting × 44
windows-7 × 38
macros × 36
microsoft-office × 35
spreadsheet × 24
csv × 22
powerpivot × 21
microsoft-office-2013 × 15
microsoft-word-2013 × 14
data-validation × 13
formatting × 12
vlookup × 12
windows × 11
keyboard-shortcuts × 11
cells × 11
power-query × 11