Other options other than VLookup 1

[uby]

Is there another option other than VLookup to get information from another workbook?

 

[xlbo]

yup - loads. Just depends what KIND of information you want and how you want to match it
INDEX/MATCH
LOOKUP
SUMIF
COUNTIF
DSUM
DMAX
DGET

More info if you want better answers please

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[uby]

Hey Geoff!

Thanks for answering!

I have a listbox and a drop down. The list box contains the fund names and the drop down contains the month of process.

When the user selects a fund name and a month of process, the pretaining information comes from another workbook with the data in it. This is information is put into a sheet in the workbook that contains the listbox and the drop down.

I know that this is as clear as mud, but the is pretty much it in a nut shell.

I hope you can understand what I am trying to explain.

Any help is appreciated.

Uby

 

[xlbo]

In which case, I would use the FIND method based on the selected items in the listbox and dropdown to find their matches in the other workbook.
If you use this kind of syntax:

dim fCell as Range
Set fCell = Workbooks("WorkbookName").worksheets("WorksheetName").columns("A").FIND("ItemToFind", lookin:=xlvalues, lookat:=xlwhole)

You can then use all properties of the range object referenceing fCell
eg the row of information is on fCell.ROW

You can then use this to create a string to ref the range you want to bring over

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[uby]

Awsome! Thanks so much!

I will try that!

Thanks again!

Uby