Hello,
I wanna fetch data horizontally from the vertical reference.
Is there any function to do this?
Seeking for help.
Thanks in advance.
Hello,
I wanna fetch data horizontally from the vertical reference.
Is there any function to do this?
Seeking for help.
Thanks in advance.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
?? Are you saying you want to find data in a VLookup, and then once found do an Hlookup off of that?
An example of your sheet, arrows and end results would help to get you to your solution.
-If you think you are done, Start over - ELeGault
Thanks for reply.
But this is not an answer to my question.
I dont want to copy from column and pate to row. Rather I wanna do lookup for the data in row and reference in column.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Draw me a picture here, because you are leaving me blank... Make a quick sample file does not need to be the actual file... just show us the layout and where you want to find what. Then maybe we can give a solution to this confusion.
Horizontal Lookup for verticle reference.xlsx
Refer attached file for details of my query
You need a Vlookup,
this would look like this in H4 of your example=VLookup(Value,Range,ColIndex,MatchType)
Value is going to be the item you are looking upPlease Login or Register to view this content.
Range is going to be where you would find that item (What column to start with) and where you want to look up to, so what column to end with.
ColIndex is how many columns you want to go over in your range once you find that value (Item), for your example was 2, From B to C
Match type is Exact or Close match False = Exact, True = Close
Once a sheet is available... everything becomes possible (well it worked this time!!)
Right! and yea you can go with an Index Match as well (which in reality is the best form of lookups) which you will find in Glenn's example
Thank you all.
It worked for me.
Happy to help - Be sure to mark your thread as Solved under Thread Tools above your first post on the right.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks