Ask Your Question
1

VLOOKUP betwen sheets

asked 2019-08-09 19:43:53 +0200

dimzev gravatar image

updated 2019-08-10 15:30:42 +0200

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

I want in sheet 1 , A column (empty) use the VLOOKUP and if Bn (in sheet1)= Am (in sheet 2) write “ok” in An , else this shell still empty

sheet 1 B15=”Smith” sheet 2 A32=”Smith”

put in sheet 1 A15 =”ok”

if in sheet 2 not exist “Smith” A2 still empty

thank you for your attention

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
3

answered 2019-08-10 12:12:53 +0200

gregors15 gravatar image

Hi, have a look at the attached file, I have used the function MATCH to check for the name existing in sheet 2. Let us know if it helps.C:\fakepath\LOQ_20190810.ods I am using Win 10 build 1903, and LO 6.0.7.3

edit flag offensive delete link more

Comments

Thank you!!! i like and your solution .... very practice!!!

dimzev gravatar imagedimzev ( 2019-08-10 15:28:59 +0200 )edit

My friend you give me the idea and solution :

=IFNA(VLOOKUP(G2;$Sheet2.$A$2:$C$100;1;0);" ")

or you can choose any column you want to display (1,2 or 3)

thank you very much

dimzev gravatar imagedimzev ( 2019-08-10 17:25:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-09 19:43:53 +0200

Seen: 48 times

Last updated: Aug 10