Hi,
Please find the attached sheet that i need a formula identify the supplier name AND if not available , its should give the TEXT Narration which is appearing the "B column"
THNX
Hi,
Please find the attached sheet that i need a formula identify the supplier name AND if not available , its should give the TEXT Narration which is appearing the "B column"
THNX
Maybe?
=IFERROR(VLOOKUP(B4,$A$16:$C$18,3,0),B4)
Thx...working good
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks