Using VLOOKUP with drop down menu

Question

I have constructed a drop down list and vlookup to extract data.  I would like to show my data on a different sheet from the list.  How would I construct my lookup formula to do this.  i.e. List on sheet 2 and vlookup on sheet 1.

Edith

Answer 1

It looks like you want:

=VLOOKUP(Sheet3!$D$1,Sheet3!$A$2:$B$52,2,FALSE)

or just cut G2 from sheet 3 and paste it wherever you want on Sheet1 - the formula will adjust as required.

Thank you very much.  Part of my issue was not applying absolute references and placement of the sheet reference.  I appreciate so very much your help as it now works for me.  This will save me a lot of work as I complete the project. I have tested several selections and they all work.

Again, thank you so very much

Answer 2

It looks like you want:

=VLOOKUP(Sheet3!$D$1,Sheet3!$A$2:$B$52,2,FALSE)

or just cut G2 from sheet 3 and paste it wherever you want on Sheet1 - the formula will adjust as required.

Answer 3

in my previous reply I indicated that column A range was A1:A2, I meant to say A1:A52

Answer 4

Hi,

Try this formula in cell B2 of sheet1

=VLOOKUP(A2,'sheet2'!$A$2:$B$50,2,0)

Ashish - I tried your formula, but it did not work. I have uploaded screenshots of my process produced in Paint.  I hope you can read them.  In column A is my source named competitiveEvents2 A1:A2. In Column B is the event number.  Column D is a drop down list that the user can select the event the source is =competitiveEvents2. Column G is my lookup which returns the event number from the drop down list selected in D.  What I want to be able to do is have the event number show up on sheet 1.  Right now all the data and formulas are on sheet 3

Answer 5

Hi,

Try this formula in cell B2 of sheet1

=VLOOKUP(A2,'sheet2'!$A$2:$B$50,2,0)