We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
excel spreadsheey formula using look and if
Ms-Pacman
Posts: 508 Forumite
in Techie Stuff
Are there any excel geniuses on here?
I am trying to find the right formula to get a column in 1 spreadsheet to look at 3 other spreadsheets and if it finds a certain bit of text entered, I then want it to put it in the 1st spreadsheet.
My main problem is that if it finds it in the same cell on more than 1 sheet it then missess an impotant bit of information i need.
its for 3 spreadsheets listing actions for more than 1 person, and i want the 3th one to pull out actions belonging to 1 person.
Excel help is pretty rubbish!
I am trying to find the right formula to get a column in 1 spreadsheet to look at 3 other spreadsheets and if it finds a certain bit of text entered, I then want it to put it in the 1st spreadsheet.
My main problem is that if it finds it in the same cell on more than 1 sheet it then missess an impotant bit of information i need.
its for 3 spreadsheets listing actions for more than 1 person, and i want the 3th one to pull out actions belonging to 1 person.
Excel help is pretty rubbish!
0
Comments
-
Can you post an example or PM it - I don't quite understand what you want to do.Charlie0
-
Sounds like you need to use the VLOOKUP function....more details of layout/exactly what type of data would be useful.........Gettin' There, Wherever There is......
I have a dodgy "i" key, so ignore spelling errors due to "i" issues, ...I blame Apple
0 -
Or FIND or MATCH or ....????Charlie0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.6K Work, Benefits & Business
- 603K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards