Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matching cell data between 2 sheets!
Hi guys,
Ok here is my issue: I have a workbook containing 2 sheets. One sheet contains a list of ETFs with livefeed data from Bloomberg about two different volume measures.I then use this data to do a simple calculation for the performance of each ETF. The issue is the fact that in the other sheet I want a table with the top 5 performers and the worst 5 performers. What I did in order to receive the names of the ETFs, provider, performance etc, I used the VLOOKUP function. The performance is the column on the far left. =VLOOKUP(LARGE(data!$C$4:$C$41,1),data!$C$4:$L$41, 7,TRUE) data is the sheet with the names, volumes and performance The above function for me means that it should look for the 1st largest number within the performance column(C column) and once it finds it in finds the corresponding data in the same row but in column 7 which is where the ETF name is.The TRUE is used to make sure its a match value. For some reason it is not working and I just dont understand why. I just want to isolate the top 5 performers by performance and have all the corresponding ETF data in a table. Is this wrong? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching data in 2 different work sheets | Excel Worksheet Functions | |||
Matching data in two sheets | Excel Discussion (Misc queries) | |||
Matching & retrieving data across sheets | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Matching data rows from two different sheets into a new a new one | Excel Programming |