Vlook Up Array table has Multiple Values

Hi All,

i have seen several examples where VLOOKUP works with multiple values even , however i am not getting it , i am trying to look up from another workbook I realized that VLOOKUP will only look at one row with the reference value that you select. However, my problem is that I will have multiple values in the table array that will refer to the same reference point. please help me how do i get rid of this even i did try with index match function however it also works for the same way.


here is the Formula

=VLOOKUP(A2,'[Open Data Set.xlsb]Sheet1'!$C$1:$I$468196,7,0)

We need a sample workbook, to help you really:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you so much for the quick response, here are both the sample files ,

Now i have to look up the Customer name and Bill from Open Data Set ,
when i am trying look up it is getting the values from first row
For example Bill # 8850483 , when i look up this bill Number ,not getting the names because it keeps on repeating 4 times ,
i need it should only get the value where names is present , not blank .

Why not just sort the data by the name column? Your vlookup will work fine then

because there are more columns (not enclosed ) due to size issues , i need to look up if every time i need to sort the data it would be taking long time .

I would suggest you add another column (I used column A) where the billing number with a customer name is given a suffix e.g x, so you have billing number 12345678x

in column A

=IF(D2<>"",B2&"x","")

then

=VLOOKUP($A2&"x",'[Sampls Open Data Set.xlsx]Sheet1'!$A$1:$I$468196,3,0)

Thank you everyone for all the help