Formula doubt - INDEX , MATCH OR VLOOKUP

[simran555]

Hello All,

I have an assignment on google sheet.

There is database sheet with as follows '


User ID Company Name City Group


I need to extract data from company name , City , Group ( All of these are in a drop down list side by side) to get the User ID on an another sheet. We can communicate through any desk software as well. Please help this is very important to me.

[Pepe Le Mokko]

Thread title was amended

[simran555]

sure. I WILL

[simran555]

Help !! Anyone

[AliGW]

Be patient.

[simran555]

Yes, Ma'am. I am but this is important to me as it can get me employed and has to be submitted by Sunday. I will appreciate any help I could get.

Thanks

[Pepe Le Mokko]

If you have urgent requests, perhaps commercial sites would be faster?

[AliGW]

... this is important to me as it can get me employed and has to be submitted by Sunday

I am sure it is important to you - everybody's queries here are important to them. However, this does not make your query any more important to us than anyone else's.

We are not in the business of helping you to get a job under false pretences. Clearly if you have been set this task and need to solve it by Sunday, then the prospective employer is going to expect you to have the Google Sheet skills that you would be 'borrowing' from us and to be able to demonstrate them yourself. If you get the job, you need to have these competences already: you can't keep coming back here asking us to do your job for you.

[simran555]

You are right. I will take care of it. Thanks Anyways

[AliGW]

Good luck with your job search.

[simran555]

Thank you Ma'am. Could you suggest which function i can use in this problem ?. I have tried most of the functions.