Hi, Probably you cannot find any proper formula for your problem. Following function may help you. [tools->Macro->visual basic editor] will get you to macro editor [insert-> module] and copy paste the following function.
You need to see how the function is used as formula in the attached file.
'----------------------
Option Explicit
'------------------------
Function VlookupMultiCol(match1 As String, match2 As String, col1 As Range,
col2 As Range, col3 As Range)
'match1 = cell to match first column
'match2 = cell to match second column
'col1 = range to search first match
'col2 = range to search second math
'col3 = range having results
Dim i As Integer, n As Integer
n = col1.Rows.Count
For i = 1 To n
If col1.Cells(i, 1) = match1 And col2.Cells(i, 1) = match2 Then Exit
For
Next i
VlookupMultiCol = col3.Cells(i, 1)
End Function
Akhilesh Kumar Karna
On Tue, Nov 4, 2008 at 9:57 PM, ram bhagath <[EMAIL PROTECTED]> wrote:
> Hi all,,
>
> I have attached the file, and explained the proble there only. I wanted to
> pick amount from another table by formula. I tried with vlookup i didnt get
> answer. Pls help me.
>
> Regards,
>
> Ram.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
book1.xls
Description: MS-Excel spreadsheet
