Hi,
I have a problem in conditional vlookup, I don't know If its can be solved in any other way.
I have 5 named list. 1 List is general name list of 4 other list. check the attachment.
A2 cell: 1 series selected from name list, A3 is indirect list of A2 (sub list). Conditional vlooup.jpg
The code will find, the value of A3 from the related Pig column.
Bookmarks