| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
The following formula returns WPM or CPM and other 3 letter combinations.
=IF(AG18="Chainlink","C","W")&IF(AG19="Galv","G"," P")&IF(AG20="Light","L",IF('Start Sheet'!I34="Medium","M","H")) All the combinations work and return a 3 letter combination but when I try to get the formula below to return a price from the array I cant get it to return anything beginning with €śW€ť. =VLOOKUP(AE15,AF3:AK10,2) AE15 is the 3 Letter combination. AF3:AK10 is an array of Prices. The second column is the price I want -- Regards Warren |
| 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
