CODEWITHSUNDEEP
excel
Vignesh Subramanian
Vignesh Subramanian

Reputation: 7289

Populate excel cell value from a different sheet based on value in a column

I have different excel sheets and I am trying to populate values into one sheet from another sheet by comparing the values

Sheet 1 is like below

enter image description here

Sheet 2 has below columns

enter image description here

Now if the name is same, I want to populate Email & Mobile to Sheet 1 from Sheet 2

I tried using VLOOKUP, but I am not able to get the syntax right. Any help is appreciated.

Hope my question is clear, please feel free to drop in a comment if you need any clarification, thanks

Upvotes: 0

Views: 49

Answers (1)

Rookie
Rookie

Reputation: 140

for the email:

=vlookup(a2, sheet2!A:C, 2, false)

for the Mobile #:

=vlookup(a2, sheet2!A:C, 3, false)

This is what Sheet1 will look like

Upvotes: 1

Related Questions