Trouble with vlookup
I cannot begin to explain my problem. Everything worked until I added a new column to my lookup table. Now anything after the first line retrieves a #N/A when it looks for my data. The date is there it finds the rest of it. But if it moves to a new line, that data seems to no longer be accessible. It's a repeatble form I just don't want to have to fill out again and again. So I want to use vloomup and a source table instead. This was anytime I need the information. It's right at my fingertips. Let me know what you need for information. I can send the spreadsheets as well. Thanks in advance. Also this is office 2016.
Search for a number in another sheet and replace with a different column name
I have multiple sheets in an excel file. Sheet1 has multiple columns, first column is barcode(for eg. 5463577263). I want to find this barcode in sheet2 and grab required fields using vlookup. The problem here is my sheet2 has barcode plus some number at the end of it. For eg in this case 54635772632(11 digits instead 10). Because of this my vlookup is failing. Is there is any way I can customize my vlookup to partially look for the value and do the rest of functionality of vlookup ? Really appreciate any help. Sheet1 Barcode Name 5463577263 =vlookup(A2, Sheet2!A2:C100, 2, FALSE) Sheet2 Barcode Days Name 54635772632 15 Transistor