Input text relevant to another cell

This is quite straightforward, but before we can help you will need to change your title - read the Forum Rules at the top of the screen. Also, it would help if you could describe your data layout in more detail, i.e. which cells/columns you are using, or attach a sample workbook (the FAQ describes how).

Pete

Hi,

I am using column D for Project (which has data validation) and E for Cost

D8 has a certain project in and i want E8 to input the cost for that project

Kris

Well presumably you have a table somewhere which shows the costs for each project - where is that located, and how is it laid out?

Pete

No i don't, the formula i am trying to use at the minute is:

=IF(ISNUMBER(SEARCH("project 1",D8)), "£###", IF(ISNUMBER(SEARCH("Project 2",D8)),"£###",""))

but the problem i am having is because i am using 'Data Validation -Lisa' so they can just select the project, some of the projects use the same words e.g Project 1, New Building, Old Building, Project 3 - but all have different costs, so i think it needs to be 'absolute'?

Kris

As I said before, it would help if you attach a sample workbook to your post so we can see what you have and how your data is organised. You should de-sensitize your data before posting (i.e. remove anything of a confidential nature), but retain the overall structure of the data and indicate clearly what you want to achieve.

Pete

Please see attached file of what i am trying to do,

Hope this helps!

Kris

In the attached file I've added the costs to column C in the Data sheet to make a little table. I've also set up data validation in column D of Sheet1 so you can choose from that list in the Data sheet, and then put this formula in E3:

=IFERROR(VLOOKUP(D3,Data!$B$3:$C$8,2,0),"")

This is then copied down to the bottom of your table.

Hope this helps.

Pete