how to use vlookup?
if i have 3 column in sheet a and 3 column in sheet b, i want to match 3 column in sheet with 3 column in sheet b.How ?
how to use vlookup?
if i have 3 column in sheet a and 3 column in sheet b, i want to match 3 column in sheet with 3 column in sheet b.How ?
There are quite few methods to match data with each other. Aap k pechly thread m m n aap ko aik specif thread suggest kya tha lkn shyad aap use follow na kr sake.
Jab aap n 3 columns ko match krna ho tu aap apne 3 columns ko concatenate kr lain. Assume COLUMN A+B+C has your data. in column D of both sheets
=A1&B&&C1
Now in D1 you can apply multiple formulas. YOu can use match function, vlookup with if combination. please stduy the attached sheet. jo aap ko smjh na aae tu phir poch lain. ya in formulas ko apni marzi k mutabiq enhance kr lain.
regards
Bookmarks