LinkBack URL
About LinkBacks
Hi!
Got a small problem with VLOOKUP, How do i make VLOOKUP return all the info from column C to P in the specific row that VLOOKUP looks for?
Hi!
Got a small problem with VLOOKUP, How do i make VLOOKUP return all the info from column C to P in the specific row that VLOOKUP looks for?
Hi
Can you upload a small sample workbook pls?
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.
Hi, Please check the formula in the attached file. To enter the formula, you need to select B8:P8, enter the formula with Ctrl+Shift+Enter. YOu can copy it to other cells after that.
Hi ScaniaR730
Another version, this is an ARRAY as well, CSE. This version is using the OFFSET Function & named ranges.
I haven't tried your excel's but i will do!
gonna post image of my problem, if that is ok?
This is the register
vlookup2.jpg
VLOOKUP gonna find the ID from the register and return the cells marked in the picture. When the ID-cell is empty, then the rest should be empty.
vlookup.jpg
Thanks for you help!
Last edited by ScaniaR730; 10-12-2012 at 08:12 AM.
Thanks, Sindhus. This is the way i wanted it, but can't really understand the formula so could you please just explain it quick!
Originally Posted by Sindhus
What are you exactly after!! You have had 2 perfectly good answers given to you, slightly different but producing the same result.
What's with the pictures,why don't you upload a sample file!
Are you now saying that you want to have 2 lookup criteria as highlighted Red!
VLOOKUP gonna find the ID from the register and return the cells marked in the picture. When the ID-cell is empty, then the rest should be empty.
vlookup.jpg
Well Kevin, i actually said thanks to Sindhus. Just wanted the formula explained.
Dont mind the red highlighted part, i'm gonna place a IF-formula there once i get some help with the lookup-formula.
Gonna upload the file so you guys can see my problem.
Last edited by Cutter; 10-14-2012 at 12:36 PM. Reason: Removed whole post quote
Hi ScaniaR730
Not quite sure what the problem is! Maybe as attached.
See the attached worksheet. When you enter this formula you select all the cells as highlighted and in cell B4 enter the formula:
Formula:
Please Login or Register to view this content.
CTRL + SHIFT + ENTER
Kevin
Well, there wasn't really a problem. I could have used LOOKUP in each cell to do the job but figured that there must be an easier way to do it.
Do you mind explain the formula?
Got a final problem i hope you can help me with,
Once "ID" is entered, i have to enter a number in let's say B4(Deläckra), like 0,050. Then take the info from H4, find it in 'Godskod' (A51) and return with the info from B51 and fill it in I4(Deläckra), 2220. Possible?
Hi ScaniaR730
Try the Microsoft support site, array formulas explained.
Introducing array formulas in Excel
I added two versions of VLOOKUP that don't require array. A bit easier to enter and they copy easily.
Last edited by Jacc; 10-14-2012 at 06:03 AM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
You mean like this? I put some random functions in there too, hit F9(recalc) a 100 times and check that the Godskod is correct each time.
Last edited by Jacc; 10-14-2012 at 06:52 AM.
Hi ScaniaR730, If your dobut is not clarified yet, here is the explanation. In the normal vlookup function, for the third argument "Col Index Number", I have used Column(Range)-min(Column(Range))+2. When entered in array, it will return 2,3,4,etc. So, the col index number will be increased by 1 automatically for the adjacent cells.
Thanks, Sindhus. This is the way i wanted it, but can't really understand the formula so could you please just explain it quick!
Thanks alot, Sindhus!
Well, Jacc, "ZON"-column need to be like ZON1, ZON2, ZON3 and not 1, 2, 3. Since the worksheet is gonna be save as a txt and imported to another software.
Even easier then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks