Skip to main content
Web Applications

Return to Question

deleted 4 characters in body; edited tags; edited title
Source Link
pnuts
pnuts
  • 17.8k
  • 5
  • 54
  • 103

How to perform a VlookupVLOOKUP with search column dynamic depending on input in another cell

I have the following table.:

enter image description hereData example

What I want to do is as follows.:

  1. User selects either Minor, MediumMinor, Medium or Major and that specifiesMajor to specify which column is used.
  2. User then inputs a number 1-100 and the chart then looks to find where the value follows, and returns the text in the far right column.

So if the user selects MinorMinor and inputs 99 it would return "Weapons" but if they selected MediumMedium and input 99 it would return "Armor and Shields".

I thought of one way to do this would be nested if statements with a unique VLookupVLOOKUP in each  (Exampleexample below) but I would prefer a much cleaner way to rightwrite this but I can't think of anywayany way.

If (A1="Minor",Vlookup(A2, B2:E11,4),if(A2="Medium",Vlookup(A2, C2:E11,3)ECT...)

If (A1="Minor",Vlookup(A2, B2:E11,4),if(A2="Medium",Vlookup(A2, C2:E11,3)ECT...)

How to perform a Vlookup with search column dynamic depending on input in another cell

I have the following table.

enter image description here

What I want to do is as follows.

  1. User selects either Minor, Medium, or Major and that specifies which column is used.
  2. User then inputs a number 1-100 and the chart then looks to find where the value follows and returns the text in the far right column.

So if the user selects Minor and inputs 9 it would return "Weapons" but if they selected Medium and input 9 it would return "Armor and Shields".

I thought of one way to do this would be nested if statements with a unique VLookup in each(Example below) but I would prefer a much cleaner way to right this but I can't think of anyway.

If (A1="Minor",Vlookup(A2, B2:E11,4),if(A2="Medium",Vlookup(A2, C2:E11,3)ECT...)

How to perform a VLOOKUP with search column dynamic depending on input in another cell

I have the following table:

Data example

What I want to do is as follows:

  1. User selects either Minor, Medium or Major to specify which column is used.
  2. User then inputs a number 1-100 and the chart then looks to find where the value follows, and returns the text in the far right column.

So if the user selects Minor and inputs 9 it would return "Weapons" but if they selected Medium and input 9 it would return "Armor and Shields".

I thought of one way to do this would be nested if statements with a unique VLOOKUP in each  (example below) but I would prefer a much cleaner way to write this but I can't think of any way.

If (A1="Minor",Vlookup(A2, B2:E11,4),if(A2="Medium",Vlookup(A2, C2:E11,3)ECT...)
edited title
Link
Aaron
Aaron
  • 155
  • 10

How to perform a Hlookup and then make the column found the column Vlookup useswith search column dynamic depending on input in another cell

Source Link
Aaron
Aaron
  • 155
  • 10

How to perform a Hlookup and then make the column found the column Vlookup uses

I have the following table.

enter image description here

What I want to do is as follows.

  1. User selects either Minor, Medium, or Major and that specifies which column is used.
  2. User then inputs a number 1-100 and the chart then looks to find where the value follows and returns the text in the far right column.

So if the user selects Minor and inputs 9 it would return "Weapons" but if they selected Medium and input 9 it would return "Armor and Shields".

I thought of one way to do this would be nested if statements with a unique VLookup in each(Example below) but I would prefer a much cleaner way to right this but I can't think of anyway.

If (A1="Minor",Vlookup(A2, B2:E11,4),if(A2="Medium",Vlookup(A2, C2:E11,3)ECT...)