Match one cell value to another column multiple values to return one value

**navanee** · 01-17-2015, 06:34 AM

Please help me!!!!

I have two sheets , In sheet1 I entered date in one cell to match same dates in sheet 2 column A and finally in sheet 1 column c I need to write the value "A"(just one letter) if match found else to be written "B" ,I need formula please help me.

Regards
Navanee

**Richard Buttrey** · 01-17-2015, 06:42 AM

HI,

Please upload the workbook and manually add then results you expect to see so that we can see the request in context.

**navanee** · 01-17-2015, 07:03 AM

Hi
please find attached work book , please do the needful

--- Navanee

**samba_ravi** · 01-17-2015, 07:35 AM

WHY CELL "E4" is A when there is no date in Cell "C4"

**navanee** · 01-17-2015, 07:55 AM

Hi
My back ground another sheet will fill the data in D column when I entered only date in C3 but I need to fill A or B based on cells filled in D coulmn,I hope you understand

**Raghukumarn** · 01-17-2015, 08:15 AM

Please check if this formula works for you.

**navanee** · 01-17-2015, 08:32 AM

Hi Mr.Raghukumaran
Great work !!!working !! Thanks but my second condition not satisfied , That is < if column D cell not having any values then column E cell should be Empty>

For example if D6 not having any value E6 should be empty
Please help me.

-with thanks
Navanee

**Raghukumarn** · 01-17-2015, 08:39 AM

Hi Navanee,

Updated the formula, this should sort out that problem.

If this solves your question, please tag this as solved and add reputation.

Regards,
Raghu

**samba_ravi** · 01-17-2015, 08:40 AM

Originally Posted by navanee

Hi Mr.Raghukumaran
Great work !!!working !! Thanks but my second condition not satisfied , That is < if column D cell not having any values then column E cell should be Empty>

For example if D6 not having any value E6 should be empty
Please help me.

-with thanks
Navanee

=IF(D3="","",IF(ISERROR(VLOOKUP($C$3,DATE!A:A,1,0)),"B","A"))
Addition to "Raghu Kumar N"

**navanee** · 01-17-2015, 09:06 AM

Hi Mr.Raghu
Thanks a lot, your formula solved my need , Great work

Thanks again,Reputation Added

-Navanee

Match one cell value to another column multiple values to return one value

LinkBack

Thread Tools

Rate This Thread

Display

Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Re: Match one cell value to another column multiple values to return one value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] return multiple values in 1 column via index / match

[SOLVED] Lookup multiple column values that match search criteria and return row labels in one cel

[SOLVED] Match multiple substrings in a cell against a lookup table and return concatenated values

[SOLVED] Formula (VLOOKUP vs INDEX & MATCH) to return multiple values in the same column

[SOLVED] Find / Match a cell value to another cell and return all column values

Bookmarks

Bookmarks

Posting Permissions