Match two condition and return a value

**magic_ma** · 12-08-2011, 11:54 PM

Hi

I need to lookup a unit price if two condition is met in a worksheet.

Can anyone help on this. I know this is very simple and i had done searching still cannot workout.

If PO Number = PODG1187 and Quantity=500, the return unit price will be from sheet 2 = 0.3

Thanks

**magic_ma** · 12-09-2011, 01:50 AM

Hi All,

Urgent..

Pls help

**vlady** · 12-09-2011, 02:18 AM

Hello
Try this one..

=IF(AND(B5="PODG1187",D5=500),VLOOKUP(B5,Sheet2!B5:E10,4,FALSE),"")

but look at again ur conditions. you have duplicates in the table.. maybe include date? or Invoice number...

**Wolfe_Tones** · 12-09-2011, 09:13 AM

{=INDEX(Sheet2!$E$5:$E$8,MATCH($B5&$D5,Sheet2!$B$5:$B$8&Sheet2!$D$5:$D$8,0))} Ctrl + Shift + Enter and copy down

Match two condition and return a value

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Match two condition and return a value

Re: Match two condition and return a value

Re: Match two condition and return a value

Re: Match two condition and return a value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions