Extract the value of above cell which has a particular word string

Hi,
Refer to the attached picture, If cell in Column A has date, extract the Purchase requisition number related to that.
Note: I am not able to upload the file right now due to some IT issue.

Pic.jpg

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

As I said before, I am not able to attach the sample worksheet here.

Originally Posted by Shareez Saleem

As I said before, I am not able to attach the sample worksheet here.

Didn't see that.

@Shareez Saleem

As I said before, I am not able to attach the sample worksheet here.

of course you can.

maybe your question is how to attach the file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

I know how to but right now, I am not able to do it due to some IT issue.

Try this...

Data Range

	A	B
1	Header	Header
2	Data1
3	1/1/2016	Data1
4	Data2
5	5/22/2016	Data2
6	Data3
7	5/25/2016	Data3
8	Data4
9	6/1/2016	Data4
10	6/2/2016	Data4
11	6/14/2016	Data4

This formula entered in B3 and copied down:

=IF(N(A3),LOOKUP("zzzzz",A$2:A2),"")

Thank you, how it works? why zzzzz?

The LOOKUP function is looking for the TEXT value zzzzz.

If it can't find it (which it never will), it will return the LAST (bottom-most) TEXT value in the range.

Thanks a ton Tony.

You're welcome!