Multiple formulas

  • Thread starter Thread starter edrachel
  • Start date Start date
E

edrachel

I am trying to do multiple formulas with VLOOKUP. I want to use VLOOKUP
to look on one worksheet and if the information is not found, then I
want it to return a number that is in a certain cell on another
worksheet.
example: Worksheet "rates"
State is MD located worksheet "state"
Needs to look up state on worksheet "state", do a VLOOKUP on "rates"
worksheet for the matching state. If MD is not found on the "rates"
worksheet then I want to go back to the "state" worksheet and I want
the results to be the price from a cell on the "state" worksheet.

Does this make sense???
 
=IF(ISNA(VLOOKUP()),reference to your cell on the state worksheet,VLOOKUP())

Replace the Vlookup (twice) with the vlookup on your rates sheet.

You might - if needed - even replace the referendce to your cell on the
state worksheet to a Vlookup as well.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
I think you're looking for something like this:

=IF(ISERROR(VLOOKUP(E37,H39:I44,2,FALSE)),
"",IF(ISERROR(VLOOKUP(VLOOKUP(E37,H39:I44,2,FALSE),K39:L44,2,FALSE)),
"",VLOOKUP(VLOOKUP(E37,H39:I44,2,FALSE),K39:L44,2,FALSE)))

This use the contents of cell E37 to do a lookup on the range H39 to I34.
If it doesn't find a value it returns a null. If it does find the value, it
uses the returned value to do a lookup on the range H39 to I44. Again, if
it doesn't find the value it returns a null, otherwise you get the returned
value. Adjust to meet your requirements ! If you're going to drag the
formula around you need to make the lookup ranges absolute.

Regards

Trevor
 
Back
Top