Hey all,
i have as per file attached, fixed data in column K and L
i need formula in J to read barcode from A, then compare it to K and L and get the item name
thanks for your usual help
Hey all,
i have as per file attached, fixed data in column K and L
i need formula in J to read barcode from A, then compare it to K and L and get the item name
thanks for your usual help
Which XL version are you using please? Answers are tailored to the OP's version. Please add this info to your profile. Thx
Microsoft® Excel® for Microsoft 365 MSO (Version 2109)
Please amend your profile accordingly. Thanks
YOU have to amend your profile to read O365, we can not do it for you!! Also add your approximate geographical location (e.g country).
I'm really not sure what you want, as you did not provide any expected answers.
A guess:
=IFERROR(VLOOKUP(A2,K:L,2,FALSE),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
You're welcome... and thanks.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks