| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup help
I need a Vlookup formula that will ignore everything to the left of the year
"2007" and only lookup the values "Transport charge" or "Commodity Charge". My current formula is not pulling the right data. Please Help! October 2007 Transport charge ' I need to look up the word "transport charge" and Sept 2007 Commodity Charge ' "commodity charge" below Current Formula =VLOOKUP(RIGHT($C27,LEN($C27)-FIND("2007",$C27)-4),'By Counterparty'!$J$1:$K$3,2)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
