Vlookup in another sheet?

R

Riptide

In Sheet 1, I have 3 columns. In column 'A' I have a validation in each cell
which allows me to select a players position in a fantasy hockey league that
I am in. In column 'B' I have a validation using an =indirect(A1) which will
list all the players for that position which are located on Sheet 2. Now I
want column 'C' on sheet 1 to copy over from Column 'B' on sheet 1 the
player's salary cost which is located in column 'B' on Sheet 2. Basically I
want Column 'c' on sheet 1 to tell excel to input the player's salary based
on the player's name in column 'B'. I was trying to use index formulas with
little success.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
vlookup and validation lists 1
Using vlookup on a validation list 0
Mail Merge Help 1
Make copy of workbook based on selected criteria 3
Searching based on text 7
Visio: copy text of a master shape to User-define Cells (Variable) 0
comparing sheet to sheet and adding value 1

Top