Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Vlookup and If formula 3
- DaveSharpe79
January 22, 2019 at 10:58 AM
- DaveSharpe79
January 24, 2019 at 10:15 PM
-
- Replies
- 3
- Views
- 637
3
-
-
-
-
Vlookup across multiple worksheets and list sheet names 1
- onexc
June 3, 2022 at 8:54 PM
- onexc
January 14, 2023 at 8:55 AM
-
- Replies
- 1
- Views
- 514
1
-
-
-
-
vlookup #n/a error when values exist 5
- ANku86
December 13, 2016 at 7:10 PM
- ANku86
December 13, 2016 at 10:12 PM
-
- Replies
- 5
- Views
- 9.4k
5
-
-
-
-
Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1
- jpetraityte
October 7, 2021 at 11:49 PM
- jpetraityte
November 4, 2021 at 2:43 PM
-
- Replies
- 1
- Views
- 522
1
-
-
-
-
Vlook up 5
- jpetraityte
October 28, 2020 at 10:59 PM
- jpetraityte
October 29, 2020 at 10:30 PM
-
- Replies
- 5
- Views
- 1.2k
5
-
-
-
-
Vertical lookup when the range changes. 8
- JoDor
May 11, 2020 at 7:00 PM
- JoDor
May 11, 2020 at 10:17 PM
-
- Replies
- 8
- Views
- 1.7k
8
-
-
-
-
VBA to insert IF formula to convert dates to DD/MM/YYYY 8
- Rovi
March 26, 2020 at 12:51 AM
- Rovi
March 31, 2020 at 2:53 AM
-
- Replies
- 8
- Views
- 2.5k
8
-
-
-
-
VBA Code Modification 11
- Excel&VBA
August 17, 2020 at 7:29 PM
- Excel&VBA
August 18, 2020 at 1:10 PM
-
- Replies
- 11
- Views
- 1.8k
11
-
-
-
-
Variable to excel formula
- NewbieError
October 12, 2018 at 3:34 AM
- NewbieError
October 12, 2018 at 3:34 AM
-
- Replies
- 0
- Views
- 313
-
-
-
-
Variable Holidays in Networkdays function 1
- RSquirrel
November 4, 2022 at 3:43 PM
- RSquirrel
November 9, 2022 at 8:13 AM
-
- Replies
- 1
- Views
- 374
1
-
-
-
-
Variable columns possible in Sumproduct (vlookup) formula 5
- bob22
April 3, 2017 at 5:19 PM
- bob22
April 9, 2017 at 3:42 PM
-
- Replies
- 5
- Views
- 1.9k
5
-
-
-
-
Variable Cell Reference based on Path 9
- xlbrian
April 3, 2019 at 3:25 PM
- xlbrian
April 4, 2019 at 5:49 PM
-
- Replies
- 9
- Views
- 1.6k
9
-
-
-
-
value within 3 of other cells on the row 3
- cspgsl
February 4, 2020 at 10:52 AM
- cspgsl
February 4, 2020 at 6:13 PM
-
- Replies
- 3
- Views
- 800
3
-
-
-
-
Value Distribution based on Criteria 5
- Rr111
December 7, 2022 at 6:56 AM
- Rr111
December 7, 2022 at 7:39 AM
-
- Replies
- 5
- Views
- 936
5
-
-
-
-
Validation List values from 3 columns based on INDEX MATCH of value offset from cell 3
- t.palinkas
June 10, 2018 at 11:05 PM
- t.palinkas
June 12, 2018 at 5:46 AM
-
- Replies
- 3
- Views
- 795
3
-
-
-
-
Validation List using a Table 3
- mar050703
November 11, 2017 at 2:00 PM
- mar050703
November 12, 2017 at 3:53 PM
-
- Replies
- 3
- Views
- 543
3
-
-
-
-
Validation Between 2 Sheets
- mzukowsk
November 15, 2017 at 6:42 PM
- mzukowsk
November 15, 2017 at 6:42 PM
-
- Replies
- 0
- Views
- 200
-
-
-
-
Validating for Weekday Date OR Text 2
- jzehr
April 5, 2016 at 8:33 PM
- jzehr
April 5, 2016 at 10:23 PM
-
- Replies
- 2
- Views
- 1.1k
2
-
-
-
-
Vacation entitlement calculation 3
- myexcelstar
June 13, 2019 at 2:12 PM
- myexcelstar
July 10, 2019 at 10:36 PM
-
- Replies
- 3
- Views
- 717
3
-