-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
multiple value return
-
L
Lookup that return multiple values
Hi everyone! I'm trying to figure out how to look up a value in one column and return all unique values from a different column. For example, in a workbook I have Sheet 1 with Column G listing multiple Vendor Names (starting on G7). On Sheet2, Column F also has Vendor Names and in Column J...- LostinVA
- Thread
- multiple value return
- Replies: 2
- Forum: Excel Questions
-
N
How to get Index/Match or Vlookup to return specific matching value
I'm trying to use the INDEX and MATCH (or Vlookup) function to return only a specified value ("Paper Check") if it exists. If it does not exist, I want the return value to be "No". Sample below: <tbody> A B C D E F G 1 Name Check Type Payment Method Name Paper Checks? 2 John Smith All...- nmerchant
- Thread
- if statement help index & match multiple value return range vlookup
- Replies: 2
- Forum: Excel Questions
-
S
formula for values on multiple lines
I have 400+ rows of data and want to use a formula not a pivot table to return value. I will be using the "color value" returned value in a different formula. data has item# on each row. any item number could be different colors (imagine a shirt with an item number 1111 that is available in...- smakatura
- Thread
- color countif multiple value return red sold
- Replies: 2
- Forum: Excel Questions
