Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

partial data lookup excel

Excel with two tabs (DATA & NCS FAMILY)

Looking for a formula for a cell that will do the following
Using column K from Data look into NCS FAMILY and return column B when the first two characters of DATA:K are found in Column A of NCS FAMILY   

Avatar of als315
Flag of Russian Federation image

Try something like:
=VLOOKUP(Left(K1,2),'NCS FAMILY'!$A$1:$B$4,2,False)

Open in new window

Correct range to real
Avatar of Matt Pinkston
Matt Pinkston


Getting the #N/A in all
Could  you upload sample file with few rows of data for testing? Please, show also expected result
Sample Attached
Avatar of Matt Pinkston
Matt Pinkston

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial