Ask Your Question

VLOOKUP between many sheets

asked 2019-08-10 17:29:46 +0200

dimzev gravatar image

updated 2020-08-03 12:38:50 +0200

Alex Kemp gravatar image

In sheet 1 I have 4 columns (A is empty , B,C,D) in sheet 2 I have 3 columns (A,B,C) in sheet 3 I have 3 columns (A,B,C) in sheet 4 I have 3 columns (A,B,C)

how use VLOOKUP: in sheet 1 B15=”Smith” if (in sheet 2 AND sheet 3 AND sheet 4) not exist “Smith” in column A THEN in sheet 1 , A15 still empty. if (in sheet 2 AND sheet 3 AND sheet 4) find “Smith” in column A then take the city from column B and put in the sheet 1 in column A (A15=”London”)

thank you for your attention

edit retag flag offensive close merge delete


Hello "City" is in column B of which sheet and it is really right (same row) of "Smith" in that sheet? And please specify the number of rows (the ranges) of your various sheets filled with data; otherwise any answer would reguire A:D in any range specification and thus blowing up the search, match or lookup ranges.

(For me your question sounds more or less like a How to useIF question than a VLOOKUP question)

Opaque gravatar imageOpaque ( 2019-08-10 19:22:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-08-11 14:43:38 +0200

gregors15 gravatar image

Hi, have a look at the attached, Sheet1 column D using INDEX/MATCH gets the “City” from sheet 2, column C.

Sheet1 columns D,E and F show if there is a MATCH in sheets 2,3 and 4, you then can use the results to do any checks you wish, i.e. if all 3 results are greater than 0 there is a match to each sheet, any 0 then no match.C:\fakepath\LOQ_20190810.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-10 17:29:46 +0200

Seen: 74 times

Last updated: Aug 11 '19