Hello everyone
Does anyone know how I could enter a function into a cell that would reference a part number with a list of parts on another sheet and return a specific value (a letter) if it is on the this. I think it would have to be a combination of a vlookup and an "if" function, but everytime i try it doesn't work.
Yes you should need Vlookup...
e.g.would return value in Sheet2, column B where value in column A matches A1 on the sheet with the formula in it.
Please Login or Register to view this content.
If you want a blank returned when the item is not on the sheet then...
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Maybe something like this:
It returns the letter "A" if it finds the value you want from the list (A1) and blank if it doesn´tPlease Login or Register to view this content.
Last edited by Portuga; 04-09-2008 at 03:56 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks