multiple criteria vlookup in vba userform

**kuraitori** · 07-07-2009, 03:25 PM

Hello all,

I have a problem with vlookup, some of the items in the lookup array are not unique and vlookup gets confused with multiple matches,

however if I can use a combination of 1st and second columns as the criterion then it would result in a unique match.

Problem is I don't know how to acheive this in vba (but I can with the worksheet formulas).

Any advice? (attached is a sample worksheet)

**rylo** · 07-07-2009, 09:34 PM

Hi

Using your example file, try

Please Login or Register  to view this content.

rylo

**kuraitori** · 07-09-2009, 01:19 PM

works wonderfully. thank you so much

**kuraitori** · 08-04-2009, 06:43 PM

Okay, had trouble with this when both criteria were strings.

altered line to the below solution and worked fine

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

(note extra quotation marks around code)

so full solution is

Please Login or Register  to view this content.

**kuraitori** · 08-04-2009, 07:22 PM

Okay, question. How do I use this if the list is on a different sheet than the active one?

(it doesn't like the Worksheet("List").Range("A:A") stuff

**rylo** · 08-04-2009, 09:10 PM

Hi

The function is based on the format that is used in the spreadsheet, not in VBA. So things like workbooks("").sheets("") approach is not valid. It would be something like

Please Login or Register  to view this content.

rylo

**hemaveera** · 04-04-2014, 12:41 AM

Hi,
I am unable to execute the code, where I have dates in column D3 onwards, account numbers in column G3 onwards, and the balance in column S3 onwards, I did exactly as said but it is throwing error while displaying. the date is in dd-mmm-yyyy format
balance.Value = Cells(datarow, 19).Value
please help