IF or VLOOKUP function?

Question

Hi,

This may seem like a simple question but I am having a brain freeze.

I have a dropdown menu on one sheet (made of values of sale units - i.e. 1ml, 500ml, 1ltr, 10ltrs etc). This will be used to identify sale units for products we have. However, on the cell next to it, I need to enter the multiplier - as below.

Item Code	Base unit of measure (smallest unit that we would consume that in)	Stock unit of measure (what unit would we stocktake in)	Multiplication Factor
ABACPO	1g	20kg	20000
ACAC	1ml	1ltr	1000
ACAC5	1ml	1ltr	1000

The info below has been put onto a second tab on the spreadsheet, but I need a formula for the front sheet so when I populate the 'Stock Unit of Measure', the multiplication factor populates automatically.

Unit	Multiplier
1ml	1
500ml	500
1ltr	1000
10ltr	10000
20ltr	20000
25ltr	25000
200ltr	200000
210ltr	210000
930ltr	930000
970ltr	970000
1000ltr	1000000

Any help would be appreciated.

Thanks

CeeTee992

Answer 1

Let's say the second sheet is named Unit Sheet.

In D2 on the first sheet, enter the formula

=IFERROR(VLOOKUP(C2, 'Unit Sheet'!$A$2:$B$12, 2, FALSE), "")

or

=XLOOKUP(C2, 'Unit Sheet'!$A$2:$A$12, 'Unit Sheet'!$B$2:$B$12, "")

Fill down.