I have included a mock-up document to better explain my problem.
I'm trying to implement a stock system for my company, but it to have as little human input as possible.
Thanks,
Ash Brown
I have included a mock-up document to better explain my problem.
I'm trying to implement a stock system for my company, but it to have as little human input as possible.
Thanks,
Ash Brown
Most prefer you explain the problem in the post rather than downloading a workbook and then trying to determine what you actually want. Simple enough in this case but something to remember in the future.
Use the VLOOKUP function.
In B6
=VLOOKUP($A6, $H$4:$L$7, 2)
Note the Relative/Absolute addresses.
Copy this across the columns increasing the last parameter as you go across. Finally copy the columns down as far as you want.
You will also need to handle the #N/A errors for formulas where the cell in Col A is still blank.
This worked a treat thankyou.
Sorry for not elaborating in my post, i'm new to forums.
I'll take this all onboard for the future
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks