Match col A of sheet1 and sheet2, if same value then in fetch value of col F from sheet 2

[ishin]

Hi ,

I have two sheets

Sheet 1 has columns MSISDN - subdt - unsub dt - unsuborigin
Sheet 2 has columns MSISDN - dt - type

These are two different monthly reports. I want to match col A of sheet 1 and see if that MSISDN exists in col A of sheet 2. if that MSISDN is present in sheet 2 then fetch the TYPE.

I tried Vlookup but it does give correct TYPE. is it mandatory to have unique / no dulplicates in both sheets to use vlookup?



both sheet.jpg

regards

[BFernandez]

You could try an Index Match function:
=INDEX(*Column to return*,MATCH(*Value to lookup*,*Column to lookup against*,0)
or
=INDEX(SHEET2!$E:$E,MATCH(SHEET1!A2,SHEET1A:A,)

The 0 at the end means it will look up exact values. This will find and return the first entry it finds

If you want to look up entries which arent exactly the same (E.G B Fernandez / Ben Fernandez) try the Fuzzylookup add on

Hope this helps!

[Craig K.]

Whether you are using Vlookup or the INDEX-MATCH function, the reference value needs to be unique. These functions will stop and return the first instance it comes across.