Posted to microsoft.public.excel.misc
|
|
VLOOKUP
Awesome, Thank you!!
"Max" wrote:
Try this:
=IF(OR(C8={"None";""}),"",VLOOKUP(A8&"-"&F8&"-"&G8,INDIRECT(CHOOSE(MATCH(C8,{"Internal";"Externa l"},0),"'Writing
Charges'!D3:E60","'Writing Charges'!G3:H60")),2,0)*I8)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karen Smith" wrote:
Below is the current formula I have, however, I need to change some
criteria, which now requires a change in the formula. Still the same look up,
but if c8="Internal" then vlookup D3..E60, if c8="external" then vlookup
G3..H60, if c8="none" then do nothing. How would I change the formula below
to make it work?
=IF(C8<"yes","",IF(ISNA(VLOOKUP(A8&"-"&F8&"-"&G8,'Writing
Charges'!$D$3:$E$60,2,0)),"",VLOOKUP(A8&"-"&F8&"-"&G8,'Writing
Charges'!$D$3:$E$60,2,0)*I8))
|