Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
Can you provide simple step by step instructions to do a vlookup for two
different spreadsheets? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
One simple way to teach yourself would be to
in a cell type =vlookup(3, then goto the tab and lookup table you wanthighlight ithit enter complete the ,2,false) of the formula -- Don Guillett SalesAid Software "KOL" wrote in message ... Can you provide simple step by step instructions to do a vlookup for two different spreadsheets? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html KOL wrote: Can you provide simple step by step instructions to do a vlookup for two different spreadsheets? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
YES
The Allen Wyatt version is what got me going and I don't think that I'll be able to top him: http://exceltips.vitalnews.com/Pages..._Function.html But let me go ahead and give it to you in my english. Take your cell you want to have the value posted to and type in =vlookup( Then you'll see excel 'guide' you to what you need to do next (Excel2003) Now it wants the lookup value == What number do you want it to find? Usually you've got that number in a cell so you'll probably use a cell reference like A2 Now your formula looks like =vlookup(a2, After the , excel is going to need to know where to look it up. Go ahead and use your mouse. Select the entire table. Make sure the left column is has the value you're looking up somewhere in it. Once you've got the table selected press the , DO THIS BEFORE YOU CHANGE SHEETS!!! now our formula looks like =vlookup(a2,sheet2!A1:B6, After this , it wants to know what column you want spit back at you. Starting on your table you selected count your columns. Column 1 contains the data that you looked up and keep counting from there. =vlookup(a2,sheet2!A1:B6,5, We put one more comma in and then come to a 'weird' feature. Vlookup will find the closes value if you want it to. If you're looking for the exact value you'll have to tell it to turn this feature off. I usually do. =vlookup(a2,sheet2!A1:B6,5,false) That's it! Now if you're going to copy this for multiple cells that all reference the same range make sure you make the range absolute. To do this use the $ =vlookup(a2,sheet2!$A$1:$B$6,5,false) This last one you can cut and paste but the table you selected will be the same "KOL" wrote: Can you provide simple step by step instructions to do a vlookup for two different spreadsheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |