"in" function???

  • Thread starter Thread starter ChrisP
  • Start date Start date
C

ChrisP

I have a cell that could be one of 2 values, if it's one value I want to do a
vlookup and get the associated info from another tab (this I can do). My
problem is that if one of the other 2 values are chosen I would bring back
the same value from a different tab. Can I do something like an IN statement?

For example:

if (a1 in ("exp", "cap"), .....

Thanks!
 
Without knowing all your details:
=IF(A1="exp",VLOOKUP(B1,Sheet1!A1:C100,2,0),
IF(A1="cap",VLOOKUP(B1,Sheet2!A1:C100,2,0), "")

Make the Sheet1!A1:C100 part by 'point and drag' on the correct range in
your workbook

(Please, they are "worksheets", "Tabs" are the dohickies -that's the high
tech word- you click to open worksheets. If you use the wrong word, Help
will not give you much joy)

best wishes
 
Back
Top