We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

vlookup- Array from 2 or more different tables [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-15 16:06:31.390303

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

Question Tools

1 follower

Stats

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

Seen: 144 times

Last updated: Sep 15 '17