Hi I have a vlook up problem I cant solve
what I need to do is look for a part number and return the value of components sold "simple really" the problem is, i have more than one customer with the same part number
i have tried if and countif but they don't work
can anyone solve this
Skip
Please attach a sample workbook showing what you have tried so far.
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.
hi,
A sample work book .
Punnam
Hi attached is an example of the data and the vlookup i used if in the example
i have tried countif also to look for the customer then complete the vlookup task
skip
Please attach a workbook created by you where you have attempted to use these formulae. The workbook you have attached is of no use, as far as I can see.
sample attached
Hi,
Is this what you want ?
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks