Vlookup Help

[ajeet kumar singh]

I need to know about all booking no. from Data 1 is available in Data 2 or Not with same value (Nights)

 

[eibi]

Ajeet,

Please provide 1-2 lines of an example output you want to see in Data 3.

 

[Krishna Kinker Singh]

Hi Ajeet,

If you want to check for night data then implement this,

Type formula in cell Q3=VLOOKUP($A3,$G$3:$K$228,5,FALSE)\
and in cell R3:=E3=Q3 ,
in R3 result will give True if Data is available with same value other wise result will give false in cell R3,

Drag formulae till Q199 and till r199 ,

Thanks,

Krishna

 

[Krishna Kinker Singh]

Hi Ajeet,

If you want to check for night data then implement this,

Type formula in cell Q3=VLOOKUP($A3,$G$3:$K$228,5,FALSE)\
and in cell R3:=E3=Q3 ,
in R3 result will give True if Data is available with same value other wise result will give false in cell R3,

Drag formulae till Q199 and till r199 ,

Thanks,

Krishna

You can write formula directly only in Q3 (no need to type formula in R3)

Q3=IFERROR(IF(VLOOKUP($A3,$G$3:$K$228,5,FALSE)=E3,"Available with same value","Not available with same value"),"Not Available")
Drag formula till Q199.

Hope it will work for you.


Thanks,

Krishna

 

[jayalaxmi]

see this attachment too

Regards,
Jaya