I am trying to create a vlookup based on a column that itself has a formula--I needed to use the LEFT function. Is that what is causing my vlookup results to return an N/A? Attached
I am trying to create a vlookup based on a column that itself has a formula--I needed to use the LEFT function. Is that what is causing my vlookup results to return an N/A? Attached
Nope. The issue is one is text and the other is a number. You need to make sure that they are the same type of data.
Last edited by alansidman; 08-26-2021 at 02:18 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
In I2
=--LEFT(E2,4)
Converts to numeric value
in J2
=VLOOKUP(I2,$M$1:$N$11,2,TRUE)
That did it! Thank you so much . I am sorry I omitted the instructions on the desired outcome but not only could you easily see what I was trying to do, you kindly responded. Much appreciated!!!
Last edited by Alewis06; 08-26-2021 at 02:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks