Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup 3 sheets
Hi,
I have 3 worksheets and want to combine a vlookup to find the sum of the unique criteria. I can get it to work with 2 spreadsheets but not 3. The formula i am using is: =IF(ISERROR(VLOOKUP($A99,'sheet1 v4'!$A$3:$AR$103,COLUMN(AR99),FALSE)),VLOOKUP($A99 ,'Sheet2 v4'!$A$3:$AR$98,COLUMN(AR99),FALSE),VLOOKUP($A99,' Sheet1 v4'!$A$3:$AR$103,COLUMN(AR99),FALSE)) Example: Sheet 1 Apple 2 Banana 5 Orange 11 Sheet 2 Mango 4 Banana 5 Pear 7 Sheet 3 Apple 2 Grape 1 Summary Sheet Apple 4 Banana 10 Orange 11 Pear 7 Grape 1 I must be missing something simple but can't figure it out, any help would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup across several sheets | Excel Worksheet Functions | |||
VLOOKUP Between Sheets | Excel Worksheet Functions | |||
vlookup in several sheets | Excel Worksheet Functions | |||
vlookup over 2 sheets? | Excel Worksheet Functions | |||
Vlookup from 2 different sheets | Excel Worksheet Functions |