Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have searched and searched these groups and need to ask for
assistance. Here is a sample of my data: Sheet 1 Col A Col B 2007011 A 2007012 B 2007013 C 2007014 D 2007021 E Sheet 2 Col B Col E 2007011 A 300 2007012 B 310 2007013 C 320 2007014 D 310 2007021 E 320 Using the value's in Col A & B in Sheet 1, I need to return the value in Col E in Sheet 2. I know that a vlookup will not work. Have been experimenting w/different variations of SUMPRODUCT, but cannot get it to work. Any and all help will be greatly appreciated!!! Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT Criteria Via Cell Reference?? | Excel Worksheet Functions | |||
SumProduct with criteria list | Excel Worksheet Functions | |||
Sumproduct w/date criteria not working | Excel Worksheet Functions | |||
Unique sumproduct with criteria! | Excel Worksheet Functions | |||
Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions |