Hello,
I am trying to use VLOOPUP and I have several different conditions that will have several different possible table_arrays. To accomplish this, I am determining which table_array I need to use and I want to pass that into my VLOOKUP formula as a Defined Name. Is that possible?
Please see attached.
I6-I9 determine my criteria that will tell me which table_array I need to use.
I pass that information over to AA11:AH12 and then combine it with CONCAT to yield the table_array defined name.
In a perfect world I would like to know how to modify S12 from...
=IF(OR(I6="Undecided",I7="Undecided",I8="Undecided",I9="Undecided"),"N/A",VLOOKUP(P12,HEIGHTSS,2,TRUE))
to
=IF(OR(I6="Undecided",I7="Undecided",I8="Undecided",I9="Undecided"),"N/A",VLOOKUP(P12,AH12,2,TRUE))
Bookmarks