LinkBack URL
About LinkBacks
Hi,
I have experts I have 2 sheets, 1sheet have data and 2nd sheet I want to update by SKU#, I have attached screenshot, when I put SKU# barcode and product data will be update accordingly SKU#.
Thanks in Advance.
Farhan
Hi,
I have experts I have 2 sheets, 1sheet have data and 2nd sheet I want to update by SKU#, I have attached screenshot, when I put SKU# barcode and product data will be update accordingly SKU#.
Thanks in Advance.
Farhan
Put this formula in A3 of Sheet2:
=IF($B3="","",IFERROR(INDEX(data!A:A,MATCH($B3,data!$B:$B,0)),""))
then copy down. You can also copy the formulae into column C.
Hope this helps.
Pete
Hi there,
a quick and easy to update way of doing this is with Vlookups. Add an additional column in your data sheet to allow the SKU to be at the start of your columns and you can still paste over new data into columns B, C and D. See attached sheet..
thanks
Leigh
Leigh - using VLOOKUP here is not quick and easy - as you have said yourself, it requires either the moving or duplication of a column (although there is in fact a trick to make VLOOKUP look from right to left using the CHOOSE function).
Pete's use of INDEX MATCH obviates the need to rearrange or change the data layout. I suggest that you get to know the INDEX MATCH combo and add it to your own toolbox.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks