Lookup based on multiple criteria and return value in column

**Ariff_Chowdhury** · 01-01-2019, 02:00 PM

Hello

Hope you're doing well.

Worksheet-1 contains 200,000 rows of data with more than 20 columns
Worksheet-2 contains more or less same amount of data

I want to lookup a value based on multiple criteria (columns) and return value in a single column.

Currently I am doing this through INDEX MATCH FUNCTION.

Please Login or Register  to view this content.

But it's taking too much time in calculating.
Can any of you help me proving the vba solution for that. I've tried searching the old thread but couldn't found it.

Would be grateful

Thank you.

**LeoSkywalker** · 01-01-2019, 02:16 PM

Hello,
Please post an example file.

**Ariff_Chowdhury** · 01-01-2019, 02:31 PM

Please find attached file.

I want to put UserName in sheet A by looking up a value based on multiple criteria.

The columns number number is different in my actual file file because i have deleted the unnecessary columns which are irrelevant to match. but
Like in sheet "a" column B has "ServiceNumber" but in my actually file it is placed on column AB.
Similarly in sheet "b" column A has "ServiceNumber" but in my actually file the same data is in column X

Thank you