Hello, I've only recently started using Excel and I'm stuck...
(English is my native language, that's why I didn't submit this question in the Other Languages threads. The sheets I'm making contain Chinese and English but you can just ignore the Chinese words)
This is my sheet with all the data. Sheetname: "PRICELIST單價表"
1.JPG
This is the sheet where I need to lookup data. Sheetname: "TENDERLIST"
2.JPG
I need to lookup "UNIT PRICE", but instead of just referring to "ITEM CODE" I need it to also refer to "CLASS TYPE" because my unit price varies with different class type. (EG: ITEM CODE: CL00112, C1 PRICE: $1, C2 PRICE: $2, C3: $3, C4: $4 etc.)
So I need an equation that can change my UNIT PRICE in correspondent to my CLASS TYPE.
Right now the equation for UNIT PRICE is =VLOOKUP(A20:A99,PRICELIST單價表!A3:E23,5,FALSE)
Thank you!
Bookmarks