LinkBack URL
About LinkBacks
Hi Muruganraj,
Try using below formula;-
Formula:
=IF(COUNTIF($A$2:$A2,$A2)>1,VLOOKUP($A2,INVENTORY!$A$2:$G$7,7,FALSE),VLOOKUP($A2,INVENTORY!$A:$F,6,0))
See attached:- Attachment 210325
Regards,
DILIPandey
<click on below * if this helps>
Hi Muruganraj,
Try using below formula;-
Formula:=IF(COUNTIF($A$2:$A2,$A2)>1,VLOOKUP($A2,INVENTORY!$A$2:$G$7,7,FALSE),VLOOKUP($A2,INVENTORY!$A:$F,6,0))
See attached:- Attachment 210325
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks