LinkBack URL
About LinkBacks
greetings everyone. i have this worksheet i need to write a S/N number on sheet2 and the information will be taken from sheet1 and pop up in sheet 2 using index match(preferable). it would be understood through the attachment. thnx
greetings everyone. i have this worksheet i need to write a S/N number on sheet2 and the information will be taken from sheet1 and pop up in sheet 2 using index match(preferable). it would be understood through the attachment. thnx
Hi,
In B3 copied down
Formula:
Please Login or Register to view this content.
In D3 copied down
You'll need to format D3:D19 ad 0.00" in" abd the date as a date
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Duplicate thread:
https://www.excelforum.com/showthread.php?t=1111648
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
thank u very much it worked like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks