The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
HOW TO ATTACH YOUR SAMPLE WORKBOOK:Unregistered, Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: lookups

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Team creator based on a list with different categories

Started by zed369‎, 11-13-2024 02:47 AM
- 4
- 229
Last Post By:

Last Post: 11-13-2024 12:16 PM

by AliGW

Forum:
Excel Formulas & Functions
Set values in cells based on lookups in single cells

Started by kelstrup‎, 03-06-2023 12:05 PM
- 4
- 455
Last Post By:

Last Post: 03-07-2023 04:46 PM

by kelstrup

Forum:
Excel General
[SOLVED] help with index and match that returns value based on multiple criteria

Started by miggysantini‎, 09-27-2021 06:59 PM
- 6
- 456
Last Post By:

Last Post: 09-29-2021 11:41 AM

by GeoffW283

Forum:
Excel Formulas & Functions
[SOLVED] Return Column String based on ID and Range (min and max).

Started by Jackson2806‎, 07-23-2020 07:58 PM
- 4
- 404
Last Post By:

Last Post: 07-24-2020 09:55 PM

by Jackson2806

Forum:
Excel Formulas & Functions
How to match on both ID and Date from another sheet

Started by futurehead84‎, 02-28-2019 05:01 AM
- 1
- 305
Last Post By:

Last Post: 02-28-2019 05:05 AM

by arlu1201

Forum:
Hello..Introduce yourself
[SOLVED] Excel formula based on index match between dates

Started by Sondai‎, 12-27-2018 04:26 AM
- 2
- 389
Last Post By:

Last Post: 12-27-2018 04:47 AM

by Glenn Kennedy

Forum:
Excel Formulas & Functions
[SOLVED] Lookup names based on multiple drop-down lists

Started by ClickingNoise‎, 10-09-2018 04:42 AM
- 6
- 589
Last Post By:

Last Post: 10-10-2018 08:43 AM

by ClickingNoise

Forum:
Excel Formulas & Functions
Using IF & AND statements

Started by Boooya‎, 03-22-2018 02:01 PM
- 9
- 741
Last Post By:

Last Post: 03-26-2018 02:21 PM

by Boooya

Forum:
Excel Formulas & Functions
[SOLVED] Help matching milestones that are all on different lines, but all relate to one applicati

Started by LouayHashem‎, 01-16-2017 05:44 PM
- 13
- 807
Last Post By:

Last Post: 01-18-2017 12:25 PM

by LouayHashem

Forum:
Excel Formulas & Functions
Complex lookups from pivot tables

Started by nicoan‎, 10-26-2016 10:52 AM
- 0
- 657
Last Post By:

Last Post: 10-26-2016 10:52 AM

by nicoan

Forum:
Excel General
In between dates and looking up other dates

Started by boscoordinator‎, 06-09-2016 04:26 PM
- 5
- 1,025
Last Post By:

Last Post: 06-10-2016 03:19 PM

by boscoordinator

Forum:
Excel Formulas & Functions
Lookup names that have different ordering/sequence

Started by trafsc119‎, 06-06-2016 10:01 PM
- 1
- 563
Last Post By:

Last Post: 06-06-2016 10:07 PM

by Tony Valko

Forum:
Excel Formulas & Functions
Offset / Multiple Match criteria

Started by JamesArmitage‎, 03-03-2016 10:31 AM
- 7
- 1,548
Last Post By:

Last Post: 03-09-2016 09:42 AM

by JamesArmitage

Forum:
Excel Formulas & Functions
Nesting lookup values into text

Started by ebeardsw‎, 04-01-2015 12:18 PM
- 1
- 602
Last Post By:

Last Post: 04-01-2015 01:30 PM

by igoodable

Forum:
Excel General
[SOLVED] Multiple criteria lookup functions

Started by Wizards‎, 08-06-2014 10:18 PM
- 3
- 852
Last Post By:

Last Post: 08-07-2014 01:06 AM

by micope21

Forum:
Excel Formulas & Functions
Find Within a Cell

Started by DAB84‎, 02-21-2014 10:58 AM
- 3
- 756
Last Post By:

Last Post: 02-21-2014 11:58 AM

by ragulduy

Forum:
Excel Formulas & Functions
[SOLVED] Nested IF Statements

Started by SpiritedAway‎, 08-05-2013 11:36 AM
- 4
- 985
Last Post By:

Last Post: 08-05-2013 05:24 PM

by SpiritedAway

Forum:
Excel Formulas & Functions
.row function altering lookup value?

Started by Centexcel‎, 06-27-2013 10:36 AM
- 3
- 491
Last Post By:

Last Post: 06-27-2013 02:13 PM

by Centexcel

Forum:
Excel Programming / VBA / Macros
Need Help LOOKUP MATCHING

Started by Hellobuck2013‎, 06-05-2013 05:28 PM
- 4
- 715
Last Post By:

Last Post: 06-05-2013 06:28 PM

by TMS

Forum:
Excel Formulas & Functions
simple vlook up issue...cannot figure out

Started by putitwhere‎, 05-02-2013 01:16 PM
- 3
- 645
Last Post By:

Last Post: 05-02-2013 01:25 PM

by putitwhere

Forum:
Excel Formulas & Functions
Lookups and aggregated data.

Started by putitwhere‎, 05-01-2013 01:24 PM
- 0
- 518
Last Post By:

Last Post: 05-01-2013 01:24 PM

by putitwhere

Forum:
Excel Formulas & Functions
program one table to populate from multiple tabs

Started by Jason2345‎, 02-06-2013 05:55 PM
- 0
- 794
Last Post By:

Last Post: 02-06-2013 05:55 PM

by Jason2345

Forum:
Excel Charting & Pivots
[SOLVED] =Lookup function not working, are there alternatives?

Started by bdicarlo1‎, 01-16-2013 11:47 AM
- 9
- 1,273
Last Post By:

Last Post: 01-16-2013 01:29 PM

by bdicarlo1

Forum:
Excel Formulas & Functions
Looking up values contingent upon multiple requirements

Started by ncrose7‎, 12-01-2012 07:43 PM
- 6
- 946
Last Post By:

Last Post: 12-02-2012 01:34 AM

by ncrose7

Forum:
Excel Formulas & Functions
Lookup a value in list and return a value from the same list

Started by ahsng‎, 11-16-2012 12:12 PM
- 1
- 583
Last Post By:

Last Post: 11-16-2012 04:34 PM

by 6StringJazzer

Forum:
Excel Formulas & Functions
[SOLVED] Find a specifc entry in an array with multiple entries of the key field

Started by JungleJme‎, 07-25-2012 07:34 AM
- 1
- 703
Last Post By:

Last Post: 07-25-2012 07:44 AM

by JungleJme

Forum:
Excel General
Intermittent Slow Response Time with Excel 2010

Started by jacob@thepenpoint‎, 04-30-2012 04:42 PM
- 0
- 1,798
Last Post By:

Last Post: 04-30-2012 04:42 PM

by jacob@thepenpoint

Forum:
Excel General
Help with an excel formula

Started by Shane21882‎, 11-30-2011 05:23 PM
- 4
- 938
Last Post By:

Last Post: 12-01-2011 11:31 AM

by arthurbr

Forum:
Excel General
Using a lookup function as a part of a form

Started by KaitMacN‎, 08-03-2011 12:12 PM
- 12
- 814
Last Post By:

Last Post: 08-05-2011 03:28 PM

by BigBas

Forum:
Excel Programming / VBA / Macros
Returning a Specific Cell's Column Header from a Row in an Array

Started by zpenacho‎, 06-25-2011 03:16 PM
- 5
- 941
Last Post By:

Last Post: 06-25-2011 07:29 PM

by TMS

Forum:
Excel Programming / VBA / Macros
finding a match in a list

Started by erikwvb‎, 05-17-2011 03:33 PM
- 3
- 925
Last Post By:

Last Post: 05-18-2011 12:22 PM

by erikwvb

Forum:
Excel General
Excel 2007 : How to automatically populate data

Started by jcbruin‎, 01-27-2011 07:54 PM
- 1
- 1,384
Last Post By:

Last Post: 01-31-2011 04:04 AM

by daniellehudges

Forum:
Excel General
Excel 2007 : Return a value if two columns have the same text

Started by nanoroboto‎, 01-21-2011 03:41 PM
- 4
- 2,810
Last Post By:

Last Post: 01-21-2011 04:24 PM

by nanoroboto

Forum:
Excel General
Lookup function

Started by xelhelp‎, 01-17-2011 06:26 PM
- 2
- 1,305
Last Post By:

Last Post: 01-17-2011 09:20 PM

by xelhelp

Forum:
Excel General
Lookup Customer Balance

Started by deb.bauer‎, 08-10-2010 01:06 PM
- 6
- 1,534
Last Post By:

Last Post: 08-17-2010 01:51 PM

by deb.bauer

Forum:
Excel Formulas & Functions

Results 1 to 35 of 37

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Team creator based on a list with different categories

[SOLVED] help with index and match that returns value based on multiple criteria

[SOLVED] Return Column String based on ID and Range (min and max).

[SOLVED] Excel formula based on index match between dates

[SOLVED] Lookup names based on multiple drop-down lists

[SOLVED] Help matching milestones that are all on different lines, but all relate to one applicati

[SOLVED] Multiple criteria lookup functions

[SOLVED] Nested IF Statements

[SOLVED] =Lookup function not working, are there alternatives?

[SOLVED] Find a specifc entry in an array with multiple entries of the key field