Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using v-lookup with multiple identifiers
I am trying to get results from a vlookup table but I have multiple
identifiers with the different results. E.g. EMPX Amount 003359 $1,288.74 003359 $545.23 003359 $214.77 004200 $197.87 How can I get the v-lookup to return one results for each EmPX? I am trying to reconcile 2 seperate spreadsheets |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using v-lookup with multiple identifiers
Suppose your table occupies A1:B5, with headers in row 1. Suppose you
enter the EMPX value in D2 that you want the total amount for. Then in E2 you can use this formula rather than VLOOKUP: =SUMIF(A2:A5,D2,B2:B5) Is this what you wanted? Hope this helps. Pete On Jul 1, 12:01*am, cartmr wrote: I am trying to get results from a vlookup table but I have multiple identifiers with the different results. E.g. EMPX * * Amount 003359 * $1,288.74 003359 * $545.23 003359 * $214.77 004200 * $197.87 How can I get the v-lookup to return one results for each EmPX? *I am trying to reconcile 2 seperate spreadsheets |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using v-lookup with multiple identifiers
Hi,
Which result do you want to return from your example if the identifier is 003359? -- Thanks, Shane Devenshire "cartmr" wrote: I am trying to get results from a vlookup table but I have multiple identifiers with the different results. E.g. EMPX Amount 003359 $1,288.74 003359 $545.23 003359 $214.77 004200 $197.87 How can I get the v-lookup to return one results for each EmPX? I am trying to reconcile 2 seperate spreadsheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down lists identifiers | Excel Discussion (Misc queries) | |||
What are the gray areas outside row and column identifiers? | Excel Discussion (Misc queries) | |||
add identifiers to a list of numbers | Excel Discussion (Misc queries) | |||
Hiding worksheet row and column identifiers | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel |