Hi
Please see attached file as it is simpler to show by example. I am looking for a complex formula which will find multiple lookup values based on the column and header value. I have tried a lot of formulas but can not achieve the result.
Thanks in Advance
Adeel
Example Data.xlsx
I am not sure if I follow the logic here but you can give it try
Copy and paste this formula in cell B13, drag it across and down.
=IF(B3="","",VLOOKUP("*"&RIGHT(B3,1),$A$3:$A$6,1,0))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for the formula but it didn't work. i got some values however they were incorrect as the names are not in 100% order, e.g. You could just have 3 names there and we need to find the shifts for those names so the if b3 = formula won't work in this example
Last edited by adeel726; 11-05-2013 at 10:59 AM.
Well, like I said, I had my reservations. Since there was very little explanation of the "logic" behind the conversion process and no clarity of how you arrive at certain results.
I will try to explain what i am trying to do. At the top you have wards 1-7 and on the left you have the Shifts. The user assigns the names to the shifts/wards. Now they require a "report" which basically shows it in a user view.
So the below cells are an example how they want to see the report based on Users and Wards. This will show the users that what wards they are looking after and on what shift hence you can have more than 1 shift assigned to a ward for a user.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks