Help with Comparing values and retrieving values in Excel!!!!!!

Z

zabedi

Hi,

I have absolutely no idea where to start!!!! I know it's simple but
I've never done this before...I needed to figure out how to compare
values in a row and retrieve a value if the condition is true. However
if more than one values meets that condition, I need it to remain
blank...

Like for the following example, since only the Accounting Linksys field
is occupied, the Business Unit field should return the value
"Accounting"...

Vendor Accounting Finance IT Business Unit
Linksys $30,000,000 Accounting

But if the row contains more than one value, the Business Unit field
should remain blank...
Vendor Accounting Finance IT Business Unit
Unix $40,000 $5,000 $300 --
Lycos

Can anyone help me??

Thank you so much!

Zak
 
D

Dave Peterson

Check your other post.

Hi,

I have absolutely no idea where to start!!!! I know it's simple but
I've never done this before...I needed to figure out how to compare
values in a row and retrieve a value if the condition is true. However
if more than one values meets that condition, I need it to remain
blank...

Like for the following example, since only the Accounting Linksys field
is occupied, the Business Unit field should return the value
"Accounting"...

Vendor Accounting Finance IT Business Unit
Linksys $30,000,000 Accounting

But if the row contains more than one value, the Business Unit field
should remain blank...
Vendor Accounting Finance IT Business Unit
Unix $40,000 $5,000 $300 --
Lycos

Can anyone help me??

Thank you so much!

Zak
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need help with comparing values in Excel and retrieving!!! 1
match value within any portion of lookup string in range 3
HELP! I need to make an IF Statement comparing date/time fields.. 2
Comparing values or text in 2 different workbooks 2
Retrieve member values for filters in OWC pivot table 0
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Help with expression builder in a Query to retrieve wanted dates 2
Colour a row, based on a cell value 8

Top