Help with Index Match or VLOOKUP
Closed
mwilke
Mazzaropi
- Posts
- 3
- Registration date
- Wednesday October 26, 2016
- Status
- Member
- Last seen
- March 21, 2017
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Help with Index Match or VLOOKUP
- Excel 2007 VLOOKUP and MATCH problem ✓ - Forum - Excel
- Vlookup partial match any part of text ✓ - Forum - Excel
- Vlookup if two cells match return value from third ✓ - Forum - Excel
- Facebook says no account match that information ✓ - Forum - Laptop
- We can’t give you access to this account or help with your request until we receive an accepted form of id that matches the info ✓ - Forum - Facebook
1 reply
Mazzaropi
Mar 21, 2017 at 04:10 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Mar 21, 2017 at 04:10 PM
mwilke, Good afternoon.
Try to use:
E2 --> =IFERROR(VLOOKUP(C2, $J$2:$K$21, 2, FALSE),"")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
E2 --> =IFERROR(VLOOKUP(C2, $J$2:$K$21, 2, FALSE),"")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão