Combine vlookup with if(and) functions

[bmackie97]

I am trying to run a vlookup based on different scenarios. basically, I have a file with 3 columns of data. Column A has a list of identifiers, Column B will state either "Dollars" or "Cents", and Column C will list a price. What I want to do is a vlookup to find the identifier, and if column B is Cents, take the price*100, but if it is listed as Dollars to take the price as is. Is this possible by combining a vlookup with other functions?

 

[AlphaFrog]

Hi and welcome.

Try something like this where ID is the value you want to lookup in column A.

=VLOOKUP(ID,A:C,3,0) * IF(VLOOKUP(ID,A:B,2,0)="Cents",100,1)

 

[Sal Paradise]

Assuming you can make the vlookup yourself:

VLOOKUP(Price)*IF(VLOOKUP(dollars/cents)="dollars",1,100)

 

[bmackie97]

Thanks, this worked perfectly