need to display unit price when I select product item from drop down list
can some1 plese help thanks i have attached the file
need to display unit price when I select product item from drop down list
can some1 plese help thanks i have attached the file
Didn't know which column had price so assumed col C in materials sheet
Col E would be 4, Col F would be 5 etc=VLOOKUP(D21,materials!$B$5:$G$24,2,FALSE)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thanks for your help works great can you tell me how to get ride of the #N/A
Try
or=IF(D21="","",VLOOKUP(D21,materials!$B$5:$G$24,2,FALSE))
VBA Noob=IF(ISNA(VLOOKUP(D21,materials!$B$5:$G$24,2,FALSE)),"",VLOOKUP(D21,materials!$B$5:$G$24,2,FALSE))
thanks for that works great
Glad it helped
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks