vlookup + index + match - Search Results

[SOLVED] An array using vlookup/match or index/match or other pulling from multiple sheets.

Started by MikeInAu‎, 01-02-2024 11:36 PM

8

220

Last Post By:: Last Post: 01-04-2024 12:33 AM; by MikeInAu

Forum:
Excel Formulas & Functions

Lookup with conditions

Started by AbouMTL‎, 08-30-2022 02:01 PM

12

345

Last Post By:: Last Post: 08-31-2022 12:09 PM; by AbouMTL

Forum:
Excel Formulas & Functions

[SOLVED] Collate data from other sheets by list selection

Started by ~TaC~‎, 07-26-2022 04:12 AM

data collation, dropdown selection, index & match, list box, vlookup + index + match

8

544

Last Post By:: Last Post: 07-29-2022 07:18 PM; by ~TaC~

Forum:
Excel Formulas & Functions

index match or vlookup match across multiple worksheets & get location of data

Started by caluflower‎, 08-20-2020 05:49 PM

index & match, sheetnames, vlookup + index + match

1

2,004

Last Post By:: Last Post: 08-22-2020 04:47 PM; by JeteMc

Forum:
Excel General

Long Computational Time for INDEX/MATCH, Can it be reduced?

Started by drakeyboii‎, 08-19-2020 06:14 PM

5

278

Last Post By:: Last Post: 08-19-2020 08:20 PM; by MrShorty

Forum:
Excel Programming / VBA / Macros

[SOLVED] For each code, i want to rank the outlet by qty sold (largest to smallest)

Started by sillston‎, 06-22-2020 07:06 PM

index & match, large and small, rank, vlookup + index + match

2

466

Last Post By:: Last Post: 06-23-2020 12:47 AM; by sillston

Forum:
Excel Formulas & Functions

INDEX/MATCH to return the result from 12 different sheets.

Started by greatinfoteam‎, 03-21-2020 06:47 AM

index/match/indirect, vlookup + index + match

10

500

Last Post By:: Last Post: 03-28-2020 11:31 AM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] Vlookup matching one or the other

Started by Murf73‎, 02-29-2020 06:19 PM

10

494

Last Post By:: Last Post: 03-01-2020 05:17 PM; by Murf73

Forum:
Excel Formulas & Functions

[SOLVED] Use VLOOKUP in multiple sheets

Started by ravi2aks‎, 01-02-2020 09:29 AM

9

668

Last Post By:: Last Post: 01-03-2020 09:33 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] How to compare when values changed and return the heading of that column of change

Started by godfreytom2000‎, 10-30-2019 11:57 AM

6

356

Last Post By:: Last Post: 10-30-2019 05:03 PM; by godfreytom2000

Forum:
Excel Formulas & Functions

[SOLVED] VLOOKUP with CHOOSE - returning #N/A but works using F9 calculation in formula bar

Started by ex-wiz‎, 10-25-2019 01:23 PM

choose function, vlookup, vlookup #n/a, vlookup + index + match

6

871

Last Post By:: Last Post: 10-28-2019 06:19 AM; by ex-wiz

Forum:
Excel Formulas & Functions

Multiple references in one formula. Tried SUMIF, VLOOKUP, INDEX, and MATCH.

Started by lazers26‎, 07-23-2019 05:37 PM

index and match function, sumif and index and match, vlookup + index + match

3

399

Last Post By:: Last Post: 07-24-2019 10:23 AM; by TMS

Forum:
Excel Formulas & Functions

Roster Days to Hours per Week?

Started by Gazsim‎, 12-14-2018 09:27 AM

9

482

Last Post By:: Last Post: 12-17-2018 10:32 AM; by Bo_Ry

Forum:
Excel Formulas & Functions

[SOLVED] Excel formulas based on inventory management

Started by Sondai‎, 10-30-2018 05:34 AM

countif and sumif, duplicate cell contents, vlookup + index + match

7

1,273

Last Post By:: Last Post: 10-30-2018 07:44 AM; by Sondai

Forum:
Excel Formulas & Functions

[SOLVED] Multiple index+match formulas to get non-zero value data from column and return row value

Started by excel-lent13‎, 10-02-2018 05:25 PM

complex formula, complex formula/array, vlookup + index + match

14

1,442

Last Post By:: Last Post: 10-03-2018 02:05 PM; by Pete_UK

Forum:
Excel Formulas & Functions

[SOLVED] lookup and vlookup or index with combined with a nested IF?

Started by siroco79‎, 09-05-2018 11:49 AM

vlookup & match, vlookup + index + match

7

714

Last Post By:: Last Post: 09-13-2018 11:29 AM; by siroco79

Forum:
Excel Formulas & Functions

VLOOKUP and interpolation formula

Started by jaychu‎, 08-22-2018 12:20 AM

3

2,701

Last Post By:: Last Post: 08-22-2018 01:38 AM; by FDibbins

Forum:
Excel Formulas & Functions

Vlookup with closest matchng date

Started by jexcel123‎, 06-14-2018 06:16 PM

date array, duplicate criteria, vlookup, vlookup & nested vlookup, vlookup + index + match

5

916

Last Post By:: Last Post: 06-17-2018 08:31 AM; by AliGW

Forum:
Excel General

[SOLVED] Help Extracting Data- Probably VBA for looping?

Started by flexchick‎, 01-27-2018 06:44 PM

formula assistance, macro, vba, vlookup + index + match

24

898

Last Post By:: Last Post: 01-27-2018 11:39 PM; by jindon

Forum:
Excel Programming / VBA / Macros

i need to look up data from different tables (vlookup?)

Started by alisonVA‎, 12-07-2017 06:05 AM

8

478

Last Post By:: Last Post: 12-11-2017 12:01 AM; by FlameRetired

Forum:
Excel Formulas & Functions

Multiple data by using Vlookup + Index and Match

Started by EthanK‎, 10-16-2017 08:46 AM

1

373

Last Post By:: Last Post: 10-16-2017 08:49 AM; by AliGW

Forum:
Excel Formulas & Functions

Excel VBA VLOOKUP, INDEX, dget, IF, Database

Started by Rubenlarsen‎, 08-22-2017 03:43 PM

database connection, dget, vba, vlookup + index + match

0

539

Last Post By:: Last Post: 08-22-2017 03:43 PM; by Rubenlarsen

Forum:
Excel Programming / VBA / Macros

Complex Multi-Sheet Vlookup for Cross Workbook Reference

Started by DemRulesDoe‎, 07-05-2017 03:08 PM

multiple array match, vlookup + index + match, workbook connections

3

668

Last Post By:: Last Post: 09-21-2017 04:25 PM; by Aardigspook

Forum:
Excel Formulas & Functions

Which Formula to use for comparing multiple data points?

Started by DSJMonster‎, 04-27-2017 08:13 AM

????, vlookup, vlookup & match, vlookup + index + match

1

361

Last Post By:: Last Post: 04-27-2017 08:17 AM; by Special-K

Forum:
Excel Formulas & Functions

[SOLVED] Using Vlookup for Excel Invoice

Started by tgebert‎, 12-09-2016 01:08 PM

15

1,416

Last Post By:: Last Post: 12-09-2016 09:41 PM; by JBeaucaire

Forum:
Excel Formulas & Functions

Shipping Calculator with a twist - any efficient one line formula to accomplish this?

Started by sharry20‎, 10-11-2016 11:16 AM

courier cost, range formulas, shipping calculator, vlookup + index + match

2

436

Last Post By:: Last Post: 10-11-2016 12:49 PM; by sharry20

Forum:
Excel Formulas & Functions

Find Value Anywhere in another worksheet

Started by roxsingh‎, 08-17-2016 09:19 AM

formulas, formulas and functions, vlookup &, vlookup + index + match

8

2,568

Last Post By:: Last Post: 08-17-2016 12:22 PM; by Tony Valko

Forum:
Excel Formulas & Functions

[SOLVED] how to update a sheets based on value of cells in a column in another sheet

Started by shaibiav‎, 07-03-2016 10:45 AM

countif, offset, vlookup + index + match, vlookup 2 conditions, vlookup ;case

8

1,649

Last Post By:: Last Post: 07-05-2016 08:30 AM; by JeteMc

Forum:
Excel Formulas & Functions

Search Through a Column to Find Match, ignore blanks return Value

Started by lmc2016‎, 05-13-2016 11:00 AM

3

1,853

Last Post By:: Last Post: 05-13-2016 11:39 AM; by DBY

Forum:
Excel Formulas & Functions

Match/Vlookup Error

Started by Gblack686‎, 05-10-2016 07:24 PM

4

474

Last Post By:: Last Post: 05-10-2016 08:51 PM; by Tony Valko

Forum:
Excel Formulas & Functions

VLookup/IF Find data by two criterias, input results into differant worksheet

Started by bbell2219‎, 02-16-2016 09:58 PM

daily data, macro - excel programming, vlookup + index + match, vlookup 2 conditions, weekly data

1

805

Last Post By:: Last Post: 02-16-2016 10:37 PM; by bebo021999

Forum:
Excel Programming / VBA / Macros

[SOLVED] VLOOKUP returning the wrong value

Started by ortmll‎, 10-08-2015 11:52 AM

4

5,897

Last Post By:: Last Post: 10-08-2015 12:24 PM; by Jonmo1

Forum:
Excel Formulas & Functions

Vlookup returning multiple values

Started by mridul127‎, 04-01-2015 06:55 PM

index & match, match, vlookup + index + match

7

788

Last Post By:: Last Post: 04-01-2015 09:18 PM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] Matching multiple categories in mixed order

Started by mumra_2790‎, 02-27-2015 01:18 PM

3

525

Last Post By:: Last Post: 02-27-2015 02:56 PM; by mumra_2790

Forum:
Excel Formulas & Functions

Looking for alternative to array function for looking up 1 criteria and listing all result

Started by kthom‎, 01-29-2015 08:32 AM

custom formula, multiple occurences, off set, vba / macro, vlookup + index + match

5

830

Last Post By:: Last Post: 01-30-2015 04:38 AM; by Glenn Kennedy

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.00 seconds.

[SOLVED] An array using vlookup/match or index/match or other pulling from multiple sheets.

Lookup with conditions

[SOLVED] Collate data from other sheets by list selection

index match or vlookup match across multiple worksheets & get location of data

Long Computational Time for INDEX/MATCH, Can it be reduced?

[SOLVED] For each code, i want to rank the outlet by qty sold (largest to smallest)

INDEX/MATCH to return the result from 12 different sheets.

[SOLVED] Vlookup matching one or the other

[SOLVED] Use VLOOKUP in multiple sheets

[SOLVED] How to compare when values changed and return the heading of that column of change

[SOLVED] VLOOKUP with CHOOSE - returning #N/A but works using F9 calculation in formula bar

Multiple references in one formula. Tried SUMIF, VLOOKUP, INDEX, and MATCH.

Roster Days to Hours per Week?

[SOLVED] Excel formulas based on inventory management

[SOLVED] Multiple index+match formulas to get non-zero value data from column and return row value

[SOLVED] lookup and vlookup or index with combined with a nested IF?

VLOOKUP and interpolation formula

Vlookup with closest matchng date

[SOLVED] Help Extracting Data- Probably VBA for looping?

i need to look up data from different tables (vlookup?)

Multiple data by using Vlookup + Index and Match

Excel VBA VLOOKUP, INDEX, dget, IF, Database

Complex Multi-Sheet Vlookup for Cross Workbook Reference

Which Formula to use for comparing multiple data points?

[SOLVED] Using Vlookup for Excel Invoice

Shipping Calculator with a twist - any efficient one line formula to accomplish this?

Find Value Anywhere in another worksheet

[SOLVED] how to update a sheets based on value of cells in a column in another sheet

Search Through a Column to Find Match, ignore blanks return Value

Match/Vlookup Error

VLookup/IF Find data by two criterias, input results into differant worksheet

[SOLVED] VLOOKUP returning the wrong value

Vlookup returning multiple values

[SOLVED] Matching multiple categories in mixed order

Looking for alternative to array function for looking up 1 criteria and listing all result