# INDEX/MATCH SOLUTION EVADING ME

Copper Contributor

# INDEX/MATCH SOLUTION EVADING ME

I am attempting to return the value of other columns much like a VLOOKUP would; however, I need to find the applicable row/column to ensure a match and then if true return data from another column on that row and if there is no match I need to indicate as such. Attached is an example of what I have losing sleep over.

3 Replies

# Re: INDEX/MATCH SOLUTION EVADING ME

CSV

Lookup Reference,WHAT ROW IS LOOKUP IN,WHAT COLUMN,INDEX/MATCH RESULT,"VALUE OF DATA IN ""DATA I NEED"" WHERE A# MATCHES F2:H6",COL1,COL2,COL3,DATA I NEED
pear,,,,,random,random,apples,myvalue1
apples,,,,,random,oranges,random,myvalue2
oranges,,,,,strawberries,random,random,myvalue3
strawberries,,,,,random,random,banana,myvalue4
banana,,,,,random,no-match,random,
,,,,,,,,
,,,,,,,,

# Re: INDEX/MATCH SOLUTION EVADING ME

This is the formula for row in cell B2. The formula is filled down and returns an error message if the value isn't found. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.

In cell C2:

The formula is filled down and returns an error message if the value isn't found. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.

In cell D2: