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