I have a column of SKU's in worksheet1 and in ws2 I have 2 columns of SKU's and 1 column of the sku description. I want to have vlookup pull the description from ws2 and populate it into a blank column in worksheet1, but I need it to search both columns of SKU's.
Is this possible?
Last edited by budchevy; 04-20-2011 at 08:09 PM. Reason: Solved
That should be possible using IFERROR() and VLOOKUP() combinations.
Can you upload a small sample file (with any private data removed)?
On the RC12 w/s I have the SKU and what would normally be a blank description. I import data into the datadump w/s. I need the RC12 page to search for the SKU in column A and if it can't find the SKU I need it to search column B and then return the text from column 3.
Now there will be instances where it won't find the SKU in either column so I need to account for that also.
thanks..
Does this do what you want:
=IF(ISNA(VLOOKUP(C2,'data dump'!A:C,3,FALSE)),IF(ISNA(VLOOKUP(C2,'data dump'!B:C,2,FALSE)),"Not Found",VLOOKUP(C2,'data dump'!B:C,2,FALSE)),VLOOKUP(C2,'data dump'!A:C,3,FALSE))
Regards
Last edited by TMS; 04-20-2011 at 06:09 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
worked... thanks for the help
2007 (not tested):
=IFERROR(VLOOKUP(C2,'data dump'!A:C,3,FALSE),IFERROR(VLOOKUP(C2,'data dump'!B:C,2,FALSE),"Not Found"))
Regards
I would have said
tested
Please Login or Register to view this content.
Regardless of your choice - don't forget to mark your thread as SOLVED.
@Cutter: nice to have choices.
In this case, assuming the syntax is correct, I prefer my solution as it more closely links the error condition with the formula that generated it. But whatever ...
@TMShucks
I only posted mine because I only saw your first suggestion. Since OP's profile and sample file format indicate IFERROR() compatibility I didn't think your suggestion was appropriate. But by the time I posted you had already provided the IFERROR() route. As for the difference between mine and yours (2nd one) - neither here nor there.
Thank you both for the information. Great resources..
@Cutter: I have to be honest, I only posted the first solution because I was working in 2003 at the time. When I checked the profile, I thought I'd better offer the 2007 equivalent ... hence, untested. Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks