Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup in VBA - 30 sheet lookup
Hi,
I was wondering if you could kindly offer me a solution to do 2 lookups in VBA: -To lookup column D in 30 sheets in a workbook into column (D) of 1 sheet which is normally kept in another location (but can be copied across if need b). -Then the other way around, so a lookup from the 1 sheet into the 20 sheets (i already have a formula for this but would like to do it in VBA instead, trying to do a formula for the above is not easy enough - there would be too many lookups!) I would like the results to be displayed on a new sheet..and hoping that a click of a button would display the desired results. hope im making sense.. thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to lookup a sheet, number, then display in origonal sheet | New Users to Excel | |||
=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B | Excel Worksheet Functions | |||
lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions |