Return value different than "" from a data array.

[markom92]

Good afternoon! I've been struggling with this issue, and so far I haven't been able to solve it. I have a complex date master, consisting of the following:

7 item categories (i.e. A,B,C,D,E,F,G) each letter represents a different component for each item type. I've performed a Vlookup which returns either "" or a serial number (i.e. 123NDXXX092).

Vlookup formula used

=IF(IFERROR(VLOOKUP("*"&R2&"*",'48A4D050-G-621EE'!$D$2:$D$2000,1,0),"")<>"",VLOOKUP("*"&R2&"*",'48A4D050-G-621EE'!$D$2:$D$2000,1,0),"")

*****

Item B, for instance, has 420 rows, of which only one row returns a serial number, whilst the others return "" with the already mentioned Vlookup formula.

Trouble comes when trying to make the summary. I've a table listed

Item Serial Number
A -
B -
C -
D -
E -
F -
G -

I want it to show the row which return a result different from "", since only one row out of the total array will have a serial number. I've tried the following formula but it only works for the arrays which have the result on the top row:

=IF(INDIRECT(U6)<>"",INDIRECT(U6),"")

Whereas U6 is the name of the data array.

I deeply appreciate in beforehand all of your help. If additional information is needed, feel free to ask for it.

Regards!

[Pepe Le Mokko]

This thread is marked "Solved" is this correct?

[markom92]

Nope! It shouldn't be marked as solved yet! Thanks for noticing it!

Admin note - Marked the thread as unsolved for you.