| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to deal with multiple matches on vlookup?
doing a vlookup on company name - it may appear numerous times in the
spreadsheet I am looking up from, but I can't tell how it determines which value to return. For example, Company ABC listed in 4 rows, 3 of which have "no" and 1 has "yes". I want the yes. I have sorted alphabetically, thinking it returns the first one. Need advice. Thanks.....Ash |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP with multiple first column matches | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
| vlookup with multiple lines of same value | Excel Worksheet Functions | |||
| vlookup over multiple worksheets | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
