Excel formula - Confirm date and display info?

[wolf1988]

Hi


I'm not the most experienced with excel but trying to automate a task I have to do each month at my voluntary group. Below I've posted a rough idea of what I want to do but I'm not sure how to about it.


Sheet 1 - Pro
a2 - Date
B2 - Info

Sheet 2 - Task

b1 - =Date(xx,xx,xx)


b2 -


So i want to know if I can get Task B2 to check B1 for the date then look at Pro A2 to confirm or find a date and if found display info found in b2?

Would appreciate an help.

 

[Joe4]

Welcome to the Board!

I think your question may be clearer to people if you can show us some sample data and expected output.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fathermole]

 

[MARK858]

Isn't it just replacing the TRUE with Pro!B2 Edit: although @Joe4 is probably nearer to what you want with what he has posted in post 3

Book1
	A	B
1
2	22/11/2024	This is the info
Pro

Result with B2 formatted as number

Book1
	A	B
1		45618
2		This is the info
Sheet5

Cell Formulas
Range	Formula
B2	B2	=IF(B1=Pro!A2,Pro!B2,"No Match")

Result with B2 formatted as Date

Book1
	A	B
1		22/11/2024
2		This is the info
Sheet5

Cell Formulas
Range	Formula
B2	B2	=IF(B1=Pro!A2,Pro!B2,"No Match")

 

[Joe4]

So, if I am understanding this, you want to take the take from cell B1, and look in column A of the "Pro" sheet for its match, and if it finds it, return the value from column B of that same row of the Pro sheet? And if no match is found, print "No Match"? I am assuming that you really have more than one row of data to search through on your Pro sheet.

Let's say that you have data in rows 2:100 on your Pro sheet. Then the formula to put into cell B2 on your other sheet would look something like this:

=IFERROR(VLOOKUP(B1,Pro!$A$2:$B$100,2,0),"No Match")