Formula for looking in multiple fields for data and taking the completed field

**Shooter84** · 06-01-2012, 08:56 AM

Afternoon all.

Wondering if anyone is able to offer a conclusion to the formula requirement that I have.

So I work in the telecoms industry and want to create a cost profile based on one of two employee entered fields.

Lets refer to these as A1 & B1:

A1= Total Minutes & B1= Total Spend, what Im looking to do is take the data from ONE of these fields and use this to create a cost profile on a separate tab, however, I cannot work out the formula to look in BOTH fields and bring back the information from only one of them.

Can anyone help ... I feel hours of my life draining from me!!

Oh and Secondly if information is entered into one of these fields, how do I formularise (no idea if that's actually a word) it so that the other field becomes irrelevant?

Many thanks you wonderfull and smart group ; )

**zbor** · 06-01-2012, 08:58 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**Fotis1991** · 06-01-2012, 09:00 AM

Hi and welcome to the forum.

1) Pls, spend a minute and change your title, according to the forum rules(See at the top of the page)

2)Ii will better for allif you upload a small sample workbook.

**Fotis1991** · 06-01-2012, 09:29 AM

What formula are you using? Don't you have a sample workbook?

**Shooter84** · 06-01-2012, 10:05 AM

That's what Im looking for; a formula to do this calculation, if it werent for the fact that I'm trying to look in multiple fields for the data, I'd simply use a Vlookup and select the cell in which the data is to be entered, however, given that there are two fields which I want to search for data (only one of them is to be used at a time), i'm at a loss.