• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vlookup or another formula

Hello

I think I need a vlookup formula for this to work but I might be wrong.

I have attached a spreadsheet to show you what I am looking for

F3 is a dropdown box with Test A, Test B, Test C

Upon choosing from the drop down box I want the pupils percentage for that test to show up

If I choose Test A in F3 in sheet 1 I want the data from sheet 2 B2 to display the percentage for Test A

If I choose Test B in F3 in sheet 1 I want the data from sheet 2 D2

If I choose Test C in F3 in sheet 1 I want the data from sheet 2 F2

Mark
 

Attachments

  • Excel Help request.xlsx
    23.6 KB · Views: 2
Hello

I think I need a vlookup formula for this to work but I might be wrong.

I have attached a spreadsheet to show you what I am looking for

F3 is a dropdown box with Test A, Test B, Test C

Upon choosing from the drop down box I want the pupils percentage for that test to show up

If I choose Test A in F3 in sheet 1 I want the data from sheet 2 B2 to display the percentage for Test A

If I choose Test B in F3 in sheet 1 I want the data from sheet 2 D2

If I choose Test C in F3 in sheet 1 I want the data from sheet 2 F2

Mark

Hi Mark,

You need If function to get the output. Please refer the sheet I have attached.

Thanks
Sachin Gupta
 

Attachments

  • Excel_Help_request.xlsx
    24.5 KB · Views: 2
Hi Mark ,

You can use VLOOKUP too ; see if the following works :

=VLOOKUP(A4,Sheet2!$A$2:$F$39,MATCH(F$3,Sheet2!$A$2:$F$2,0),FALSE)

Narayan
 
Back
Top