Retreiving Data from VLookUp

Hi All,

I need help with some stuff regarding to VLOOKUP. Right now I have a work book with 2 tabs (ie...tab1=MIKE and tab2=MICHAEL)...I would like to know, how can I do a VLOOKUP where if a value matches, all the info on that roll will transfer to the other tab..(example...mike has a value of 10 and other info in that row underneath column a,b,c,d...when i type in the value 10 on michael's tab all the info on mike's tab will transfer to michael's tab)..THANK YOU!

update....it doesn't necessary need to be vlookup...but i need a formula that will do the functions that I have described earlier. Thank you.

Thank you so much. This works!

Another question...now that this works for tabs in the same workbook, can it do the same from another workbook. For example, typing in the number and having all the other info from another workbook import into the tab "michael"? If this is possible, please show. Thank you!

Hi Ratcat,

Thank you so much for you help! I really appreciate you helping me. These two explanations are very useful for me at the moment right now. We use a lot of vlookup here at my work. These will really help with what we are trying to figure out to do with a spreadsheet that I'm trying to create.

If not too much, I have one last question. Going back to my first post that you've replied, how can I make it so that it will only look up a certain columns rather than the whole columns. In your first reply you sent me the spreadsheet, that once I've entered 10 it will pull all the info from row 3 columns (B,C,D,E). What if I would just like them to link only row 3 columns (C and E) only? This should be my last question, I hope it's not too much. In regards, you have been a GRRREATT help!

Thank you. This information has helped me in getting started with what I am trying to do. I would like to know if it is possible to use vlookup for selecting contents within a combo box within a form. For example, depending on what is chosen from the combo box, I would like to have another cell auto complete with information pertinent to this selection. Is it possible to add a text box to a form that would autofill with information like this? I hope that my intentions are clear, as it is diccicult to relate in words exactly what I am trying to do. Thanks.