Ask Your Question
0

vlookup- Array from 2 or more different tables

asked 2017-09-15 10:57:47 +0200

dimzev gravatar image

How cam use VLOOKUP(SearchCriterion; Array; Index; Sorted) take Array from 2 or more different tables in different Sheets?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-09-15 10:58:25 +0200

dimzev gravatar image

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)),"")

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-15 10:57:47 +0200

Seen: 34 times

Last updated: Sep 15 '17