Hello,
I have used Vlookup formulas before but I seem to be stumped with one I am currently working on. Im not even sure if Vlookup is the correct type for what I am needing. I would greatly appreciate any assistance.
I have item numbers in column B that will stretch down to about 15000 rows, both letters and numbers.
I will have data in Column L and use a =RIGHT equation to get the item number from column L and populate that in Column M.
All that to say that if a match is found in column M and B then I need it to return the C & D columns of the match. I keep getting an N/A error rather I try to use Vlookup or some type of MATCH formula. I think it may be because the formula =RIGHT isnt formatting correctly... but im not sure. I attached an example workbook to this post.
Thank you in advance for any assistance.
Bookmarks