How cam use VLOOKUP(SearchCriterion; Array; Index; Sorted) take Array from 2 or more different tables in different Sheets?
example for 2 tables:
=IFNA(IF($A1="",VLOOKUP($A1,$‘Sheet1’.$J$1:$K$34,2,0),VLOOKUP($A1,$‘Sheet2’.$K$1:$L$134,2,0)),"")
How cam use VLOOKUP(SearchCriterion; Array; Index; Sorted) take Array from 2 or more different tables in different Sheets?
example for 2 tables:
=IFNA(IF($A1="",VLOOKUP($A1,$‘Sheet1’.$J$1:$K$34,2,0),VLOOKUP($A1,$‘Sheet2’.$K$1:$L$134,2,0)),"")