vllokup for looking values in more than one column

[mvel_sky]

For vlook up formula , I need to look up the values from 5 coloumns instead of regular one column - How can i do this , need help


Regards

Mahesh

[matklt]

i would probably suggest using index , match function if you could attach an example that would be great

[Punnam]

=index(expeted Colum,match(a1&b1&c1*d1*e1,A1:a100&b1:B100&c1:C100&d1:d100&e1:e100,0) ctrl+Shift+Enter
hi Check this
Punnam

[samba_ravi]

attach sample file with expected result

[mvel_sky]

Hi their

thanks for your quick reply , i attach one sample with my actual requirement - please give your ideas for how to do it


Regards
Mahesh Kumar

[mvel_sky]

Hi their

thanks for your reply , but my real requirment is some what differet from what u explain in the attachment . Here i atatch one sample with my actual requirment .Please have a look and suggest how to do this


Regards
mahesh Kumar

[mvel_sky]

thank u so much

i would probably suggest using index , match function if you could attach an example that would be great

[canapone]

Hi,

a possible approach: in D3

Please Login or Register  to view this content.

Array status is not necessary.

Hope it helps

[canapone]

Hi again,

here attached you can find sample file and formulas.

Hope it helps

[mvel_sky]

hi hi

its works well , Thank u so much for ur support

Regards
Mahesh Kumar

[mvel_sky]

hi

its work s , thank u so much

[canapone]

Hi,

you're welcome.

Thanks for providing feedback.

[mvel_sky]

Hi their have a nice day its works well ,Can u please explain what this stands for "*"&C3&"*"

Regards
mahesh kumar

[Punnam]

"*"&C3&"*"

to Search a specific text or string in the cell .should be addressed in between "*" on both sides

Punnam

[mvel_sky]

thank u