Need Help with this VlookUp

**GeneralRosh** · 12-06-2012, 02:15 PM

I have a problem figuring out how to use a VlookUp to do this . OK so below is my LookUp table.

Account Number and Ranges Accounty Type
Between 1000000 and 1999999 Regular Saving
Between 2000000 and 2999999 Saving Plus
Between 3000000 and 3999999 Chequing Plus
4000000 and Greater Regular Chequing

"Account Type" is a separate column.

Now i want to use a Vlookup function to find out the different account types for each customer. But the thing is, in the first column of the lookup table i have specific ranges instead of just numbers. How do i use a Vlookup to bring back the account type for lets say acct number "1003009".

**K m** · 12-06-2012, 02:31 PM

Assume you have Account Type (Range of values) in Column A and you have Acct Numbers in Column B and your lookup number in cell C1. Use the MATCH function (lookup value, lookup_array, match type) to return the proper row number. In your case, MATCH(C1, B:B) {if you leave off the match type, 0 is assumed}

Now use INDEX function to return the value INDEX(array, row number, column number)
In your case: for row number, substitute the MATCH function, MATCH(C1, B:B)

So the formula becomes:
=INDEX(A:A, MATCH(C1, B:B),1)

Need Help with this VlookUp

LinkBack

Thread Tools

Rate This Thread

Display

Need Help with this VlookUp

Re: Need Help with this VlookUp

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions