BOE

General Excel Questions & Answers

Last Post by Riny van Eekelen 4 hours ago

2 Posts

2 Users

0 Reactions

40 Views

RSS

Md Saliha

(@navsal66)

Posts: 109

Estimable Member

Topic starter

Hi All,

i have a combined invoice detaisl with BOE no. in one sheet, an other coloumn i have updated manually invoice there is any formula to pick BOE no based on megerged invoices

BOE.xlsx

This topic was modified 4 hours ago by Md Saliha

Posted : 05/05/2025 3:45 pm

Riny van Eekelen

(@riny)

Posts: 1196

Member Moderator

@navsal66

I believe this does what you need.

=FILTER($C$4:$C$11,ISNUMBER(FIND(E4,$B$4:$B$11)),"-")

BOE.xlsx

Posted : 05/05/2025 4:29 pm

Forum Jump:

Previous Topic

Next Topic

Recently viewed by users: Philip Treacy 52 minutes ago.

26 Forums
7,250 Topics
31.8 K Posts
14 Online
35.2 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

BOE

Super Globals

Options and Features