VLOOKUP betwen sheets

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

54 ●22 ●27 ●30 https://www.facebook.c...

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

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

gregors15
191 ●3 ●5

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

Comments

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

dimzev ( 2019-08-10 15:28:59 +0100 )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 ( 2019-08-10 17:25:44 +0100 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 183 times

Last updated: Aug 10 '19

VLOOKUP betwen sheets edit

1 Answer

Comments

Question Tools

Stats

Related questions

VLOOKUP betwen sheets