XLookup Question!

[Kaybailey7]

Hello! I'm doing alot of xlookups and as long as the entire column is full is works perfectly. However when I do the return result and it has some empty cells and there is an empty cell within the column I immediately get a value error. How do I fix this?!

Results

lookuparray.... all my other columns work but every cell is filled on the results return
Thanks in advance!

 

[hagia_sofia]

Are your lookup_array and return_array of the same size (I mean whether you selected arrays of the same size)?

 

[Kaybailey7]

Are your lookup_array and return_array of the same size (I mean whether you selected arrays of the same size)?

Yes! Only difference I'm seeing is that there are blanks in the ones where Excel will not perform and then there are not blanks in the ones that can complete the xlookup!

 

[AhoyNC]

How about posting a small sample of the data that's producing the error (lookup value, lookup array and return array). Also the actual formula that has the error.