Vlook up maybe

**jascer** · 03-17-2009, 12:09 PM

Im trying to achieve the formula where as i have two work sheets both with a sku coloum and a stk qty coloum.

The first worksheet shows my skus on amazon and my stock qty, The second worksheet shows my real data from my database Sku and qty. What i need to do is.

Have the formula MATCH find the product in my amazon worksheet and replace it with the matched stk figure from my ligitimate stock figure worksheet.

Basically i want to poulate the stock figures on my amazon listings so they are correct by matching them from the data from the real stock figures

Can anyone help me?

**DonkeyOte** · 03-17-2009, 01:10 PM

Not sure I follow, if you want to override existing Col D values on amazon sheet then

amazon_real!D2: =IFERROR(VLOOKUP(A2,wicked_data!A:B,2,0),0)
copied down

NOTE: above utilises IFERROR for non-matches, this function is available XL2007 onwards, your uploaded file is a 2007 extension so I'm assuming this is Viable ? (your profile says 2003)

If not use either of:

=IF(ISNA(MATCH(A2,wicked_data!A:A,0)),0,VLOOKUP(A2,wicked_data!A:B,2,0))

or

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,VLOOKUP(A2,wicked_data!A:B,2,0)))

**jascer** · 03-17-2009, 06:51 PM

Donkey ! Your actually a genius!

Thnak you so much for you help with this it worked first time!

amazon_real!D2: =IFERROR(VLOOKUP(A2,wicked_data!A:B,2,0),0)

Thank you again!

Vlook up maybe

LinkBack

Thread Tools

Rate This Thread

Display

Vlook up maybe

Re: Vlook up maybe

Re: Vlook up maybe

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions