• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find a value in a Table row

K

karmelito

New Member
Hi,
I'm just trying to solve a dynamic problem to find a value in a row of a table.
The situation is this. First, I've got to find the row of a table where a value is, and that is solved using the function MATCH. Once I know that I have to find a value in the row returned by the MATCh function I've got to find an specific value in that row. Would you please help me?

Table is a matrix from A1 to D23
I find the value I'm looking for in an specific column of that table MATCH(searchValue,Table[column],0)
Once I know the row of the whole Table where looking for, how can I find if an specific value is in that row?
For example I select a date and an employee and I want to find if an user has been working in that date. The users are in a column of the table, and all the other columns are dates, and I have to find if an specific user has been working in an specific date

Thanks in advance
Regards
Karmelo
 
I could build a sample excel file ..

I hope this meets your requirement..
 

Attachments

  • Sample.xlsx
    11 KB · Views: 14
Karmelo

To simplify solutions please attach a sample file of your data and anonymise the data if required

Ramesh's solution may well be right, but it also maybe wrong, purely because he has made assumptions about your data layout

This becomes wasted time if it is incorrect and is time that could have been used on another question.

Having a sample file allows a very specific response whilst minimising responders time
 
Hi,
thanks for your help and advice.Please find attached a test file. It's a little bit different to what Ramesh proposed.

Thanks in advance

Regards
 

Attachments

  • Test.xlsx
    10.2 KB · Views: 11
Hi,
I've been looking for in another forum, and it looks like there is no solution unless you use VBA. Do you agree?

Thanks
 
=IFERROR(INDEX(D2:J2,,MATCH(L11,INDEX(D3:J7,MATCH(L10,B3:B7,0),),0)),"No")

This will tell you what Column No. or No he didn't go to work
 
You must log in or register to reply here.
Back
Top