VLOOKUP
 

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))

VLOOKUP
 

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))

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))

VLOOKUP
 

welcome, Karen.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karen Smith" wrote in message
...
Awesome, Thank you!!